Is it possible to disaggregate based on any condition in essbase outline
SummaryIs it possible to disaggregate based on any condition in essbase outline
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.