Monday, February 20, 2012

Percentage Calucated Measure across several dimensions

> You can use tuple. For example,
> [Measures].[expenditure amount] / ([Expenditure].[All expe
nditures],
> [Measures].[expenditure amount])
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?
OliverYou can use tuple again.
[Measures].[Value] / ([Measures].[Value], [All Dim1], &#
91;All Dim2], [All
Dim3], ..., [All DimN])
Next version will support Root() for this purpose.
Ohjoo Kwon
"Oliver Kerber" <okerber@.bigfoot.de> wrote in message
news:d1jsjh$pvr$02$1@.news.t-online.com...
> 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
>

No comments:

Post a Comment