Forum Stats

  • 3,769,654 Users
  • 2,252,998 Discussions
  • 7,875,137 Comments

Discussions

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

Deepa Mohan-Oracle
Deepa Mohan-Oracle Member Posts: 32 Employee
edited Jan 8, 2021 9:23PM in Essbase On-Premise

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!


Answers

  • Srinivas Bobbala
    Srinivas Bobbala Member Posts: 856 Bronze Trophy

    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
    Srinivas Bobbala Member Posts: 856 Bronze Trophy

    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
    Srinivas Bobbala Member Posts: 856 Bronze Trophy

    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.