Distribution Ratio by using local member
I want to create the report contains distribution ratio (%) as follows:
-Members of the combination of Parent and Children in ITEM dimension are always placed in the report.
-Of course the number of items and item groups are gradually increasing year by year.
Then I want to define "ratio" as a local member.
However, I don't know how to point the cell of aggregate value in the definition of local member such as the row number of "Item Group nn".
What I had tried is:
-use EPMPOSITION : not possible
-use OFFSET function (xls) : not possible
In this case, isn't it possible to realize the report by using local member... Please teach me how to define it.
Vadim Kalinin replied
To my mind, your requirements can't be solved by local member formula. But it's possible to create dimension member formula for ratio (new ACCOUNT member) using MDX syntax.
Something like (just description):
If current member of dimension ITEM is a base member ([CALC]='N') then divide [Qty] by parent ITEM,
If not - then 1