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 their any provision to introduce intermediate measure in ASO MDX queries

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

Summary

Is their any provision to introduce intermediate measure in ASO MDX queries

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.

Please suggest any inputs available.

Regards,

Shantala H

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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