ConsolidatedAvg without feeders

Post Reply
vladino
Posts: 72
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

ConsolidatedAvg without feeders

Post by vladino » Thu Nov 23, 2017 11:12 pm

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

Post Reply