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