Is possible to get only Grand Total from olap cube?

Question

Hello

I want to get Grand Total from olap cube, how can i do this?

Answer 1

Hi Lasha,

Sure you can,this gives the grand total for the measure Sales Amount

select [Measures].[Sales Amount] on 0
from [Adventure Works]

hth,

Cees

---

Please remember to mark the replies as answers or at least vote helpfull if they help and unmark them if they provide no help.

Answer 2

Thanks Cees can i do this for three measures? like this:

select [Measures].[Sales Amount],[Measures].[Sales Amount1],[Measures].[Sales Amount2] on 0
from [Adventure Works]

Answer 3

Hi Lasha,

You can, but you should add curly braces {} because you're enclosing a set of elements, Like this:

select { [Measures].[Sales Amount],[Measures].[Sales Amount1],[Measures].[Sales Amount2] } on 0
from [Adventure Works]

good luck,

Cees

---

Please remember to mark the replies as answers or at least vote helpfull if they help and unmark them if they provide no help.