I have setup a client's cube enviornment for them which consists of a
single measure (expenditure amount). This measure represents dollars
spent on an individual expenditure.

They would also like to see a percentage that represents the percent
value of the expenditure compared to the total dollar amount of
expenditures by a top level grouping (i.e. row headings).

MSAS already calcuates the TOTAL value and displays it under the
individual expenditures. My question is how can I create a calculate
measure to calculate the percentage of each individual expenditure
compared to the total for that category?

Please keep in mind I'm very very new to MDX and any assistance will be
greatly appreciated!!!

Thanks!

Martin

You can use tuple. For example,

[Measures].[expenditure amount] / ([Expenditure].[All expenditures],
[Measures].[expenditure amount])

Ohjoo Kwon

"halil" <halemg (AT) dot (DOT) il.gov> wrote

Thanks so much!!!!!

Worked perfect!!!!!!!!

I used this formular but in my case it only works properly with one
dimension. The formular I want to write is quite simple

[Measures].[Value] / <Queryresult>

where <Queryresult> is the sum of all values. But I am a complete newby in
MDX and don't know how to accomplish it. Can anyone give me a hand?

Oliver

You can use tuple again.

[Measures].[Value] / ([Measures].[Value], [All Dim1], [All Dim2], [All
Dim3], ..., [All DimN])

Next version will support Root() for this purpose.

Ohjoo Kwon


"Oliver Kerber" <okerber (AT) bigfoot (DOT) de> wrote