If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Probability Average aggregation

Started by daya007, 28 Jul 2010 04:06:30 PM

Previous topic - Next topic

daya007

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

OLAPBPMguy

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.