You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Can we have a formula on an upper level member on ASO cube?

Received Response
10
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Summary

Can I place a formula on "YerTotal" on an ASO cube

Content

Hi,

I have a problem when we move data from Essbase to an ASO cube. The FTE data is not supposed to aggregate on YearTotal. I need to calculate the Total based on some conditions. Can I apply a formula to a rollup member in ASO??

If not possible, I will create another level 0 member where I will place the formula and I will use it for the reports as Year Total but I wanted to see if I could just place a formula on an upper level member on an ASO cube.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!