Page 1 of 1

ConsolidatedAvg without feeders

Posted: Thu Nov 23, 2017 11:12 pm
by vladino
Guys,
I need to get an average on a consolidated member for a calculated measure.

I can definitely use ConsolidatedAvg, that's for sure. But there is one showstopper here - the calculated measure is not fed. :-/ So the ConsolidatedAvg function doesn't work...

For the time dimension i can easily do a "dumb" workaround, ie. (1+2+3+...+12) / 12.
But if there's any other hierarchical dim (ie. product, segment etc.) it's not that easy to write this kind of workaround.

Is there any other way how to get an average on a consolidated member for a calculated measure that is not fed?

Appreciate any help!

BR
Vladino