COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: brianknott on 06 Aug 2012 06:52:16 PM

Title: Understanding of rules
Post by: brianknott on 06 Aug 2012 06:52:16 PM
Guys just after some guideance on rules in a cube.  I have been doing a lot of TI work but have stayed away from rules as I don't understand them.

I have a cube called 'Stage 3 - Rollup Data'.  It contains the following dimensions
Company
Scenario
Period
Rollup
Measure

In the rollup dimension I have an item that is called 02015 and I am trying to use  a rule to calculation to get the figure for this rollup.  Below is the rule.
['02015','Month']=N:['02012','Month']- (['03001','Month'] + ['03005','Month']);

In summary what I want is for every company, scenario amd period, calculate the rollup 02015 for the measure 'Month.

My rule does not not seem to do this.

My question is how do the other dimension (Company, Scenario and period) work when thay are not specified in the rule.
My thinking was that the rule would apply to every company, scenario and period but only to the rollup of 02015 and measure of 'Month' specified.

Tyring to improve my understanding of how rules work.

Brian
Title: Re: Understanding of rules
Post by: dusherwo on 07 Aug 2012 03:59:18 AM
Is 02015 a consolidated element? If so the n: will prevent the rule taking effect.
Note that additions and subtractions should be done with consolidations as they are much faster and don't need feeding eg
02015
--02012
--03001
--03005

and setting the weight for 03001 and 03005 to be -1.
Title: Re: Understanding of rules
Post by: brianknott on 07 Aug 2012 05:29:43 PM
Thanks.  02015 is a leaf node.

Is it correct to assume that leaving out dimension like company and period will mean that the rull will apply for all of the elements in these dimensions.

Brian
Title: Re: Understanding of rules
Post by: dusherwo on 08 Aug 2012 06:59:55 AM
Yes - but for the calculation you want you don't need a rule at all.