Print Page - Probability Average aggregation

Title: Probability Average aggregation
Post by: daya007 on 28 Jul 2010 04:06:30 PM

Hi
I have a cube with time dimension and in measure dim i have probability element. But theoretically probability of quarter 1 is not equal to sum of probability of jan, feb, mar. It is average of jan,feb,mar. TM1 always aggregates values as sum. How do i change it to average. I have time dim with hierarchy TotalYears->(years from 1990-2011)->Quarters->Month. Same type of aggregation(Avg) must reflect to all consolidations. How can i do that. Please help me.

Thanks
Daya

Title: Re: Probability Average aggregation
Post by: OLAPBPMguy on 29 Jul 2010 06:58:04 AM

Quote from: daya007 on 28 Jul 2010 04:06:30 PM
probability of quarter 1 is not equal to sum of probability of jan, feb, mar. It is average of jan,feb,mar. TM1 always aggregates values as sum. How do i change it to average. Please help me.

You can help yourself by reading the rules guide.

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: daya007 on 28 Jul 2010 04:06:30 PM