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

Is it possible to disaggregate based on any condition in essbase outline

edited Aug 2, 2018 2:36AM in Essbase 9 comments

Summary

Is it possible to disaggregate based on any condition in essbase outline

Content

HI All,

In one of our requirements it is required to allocate total value based on required percentage to the child members.

We are able to achieve if all the members are open by adding the percentage and allocating based on allocated percentage to child member.

But when the child member is closed, the allocation percentage value needs to omitted while allocating the amount among the other child members.

is it possible to achieve?

example is as shown below.

Note: we have already tried adding new column named intermediate measure but the total @ PPM level will not be calculated unless the model is aggregated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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