TM1 Forum

hello everyone,

Need help in the implementation of rules in Cognos TM1:

cube has dimension "period" - jan-2013 ... dec-2013, 2014, jan-2014 ... data for 2013 are made by hand, and for 2014 should
considered as

['эл1','jan-2014'] = ['эл1','jan-2013'] \ ['Total 2013']; ...

each month in 2013 divided by the sum for 2013, so we get the data for 2014.

To use in the calculation of previous period use DIMNM (DIMIX), but the data of the month divided by the sum of the year have not yet obtained.

thank you

To have a generic rule with DB() reference rather than using [ ] and having to hand-code for each single month you will need 2 attributes, one for "same month last year" and one for "Total Year Parent". Your resulting rule would then look something like.
[ 'period':{'jan-2014','feb-2014','mar-2014'....'dec-2014'} ] =
DB( 'cube', !dim1, ... AttrS( 'period', !period, 'same month last year' ) ) /
DB( 'cube', !dim1, ... AttrS( 'period', AttrS( 'period', !period, 'same month last year' ), 'total year parent' );

Thanks, I'll try as you said