How to set aggregate level for a member to Average in Planning — oracle-tech

    Forum Stats

  • 3,707,910 Users
  • 2,240,909 Discussions
  • 7,839,920 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

User_CA13TUser_CA13T Posts: 32 Employee
edited January 8 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!


Sign In or Register to comment.