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
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.
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
Yes - but for the calculation you want you don't need a rule at all.