How to set aggregate level for a member to Average in Planning

Deepa Mohan-Oracle

Hi ,

In the OEP_FS cube ,I have a member "WT Avg Contract Monthly Fee" under ACCOUNT dimension . There is another MARKET dimension is defined as MARKET->"WT Total"->" WT North"," WT South" ,"WT East"," WT West"

In the form , I need to show the average value(instead of addition) for "WT Avg Contract Monthly Fee" at the "WT Total " aggregation level .

In simple terms, if the value of "WT Avg Contract Monthly Fee" is 5 across each regions WT North, WT South,WT East,WT West , at the "WT Total" level , this needs to be 5 instead of 20.

How can this be achieved ? Screenshot attached for reference. Any inputs will be appreciated .

Thanks!

a69.jpg

a71.jpg

Srinivas Bobbala

You can apply average setting across period consolidation. That you did already. If you wanted to achieve it across. It's a custom calculation. you should think of member formula or a rule that calculates and store.

You may require to create additional member to avoid collision with standard roll up.

Srinivas Bobbala

You can apply average setting across period consolidation. That you did already. If you wanted to achieve it across. It's a custom calculation. you should think of member formula or a rule that calculates and store.

You may require to create additional member to avoid collision with standard roll up.

Srinivas Bobbala

You can apply average setting across period consolidation. That you did already. If you wanted to achieve it across. It's a custom calculation. you should think of member formula or a rule that calculates and store.

You may require to create additional member to avoid collision with standard roll up.