Getting AVERAGE in the Hierarchy Rollups

Post Reply
ExApplix
Posts: 103
Joined: Mon Sep 21, 2009 7:09 pm
OLAP Product: Cognos Tm1
Version: 10.2.2
Excel Version: 2016

Getting AVERAGE in the Hierarchy Rollups

Post by ExApplix »

In TM1 when we build a hierarchy we can do automatic aggregations (SUM and SUBTRACT - if we define negative weights) based on the hierarchy rollups.

I want to get the Average of the children values in the consolidation levels. Can we do AVERAGE within the hierarchy rollups as well?

If yes then how?
User avatar
Michel Zijlema
Site Admin
Posts: 712
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Getting AVERAGE in the Hierarchy Rollups

Post by Michel Zijlema »

Hi,

In common situations you will need to use rules to calculate averages. See the FAQ post and look for "Calculating Averages for Consolidations" - this will give you a.o. a link to this post.

Michel
Post Reply