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

Essbase function to get a summation of all branches

edited Nov 17, 2020 8:10AM in Planning 2 comments

Content

Hi 

We are transferring our data from BSO to ASO cube for aggregation.

However there is a requirement to have a interim aggregation in the BSO cube, for a certain allocation formula.

Ex: we enter a certain value at the total branch level, and we need it to be allocated branch wise according to a certain basis. Basis is again "X" at total branch level divided by "Y" Branch Wise. 

To obtain X at total branch level, we need to aggregate the data, but we do not want to perform an aggregation in the middle. 

So my requirement is to use an essbase function which calculates summation of the total branches within the formula 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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