C rules does not apply to new dimension elements
Posted: Wed Jun 10, 2015 9:07 am
Hi everyone,
I have notised strange behaviour of my Cognos TM1 rules.
I have Versions dimension where new elements are added by rule. New verions has STET applied by following rule:
[] = N: IF(!Version@='Current' % !Version@='Actual', CONTINUE, STET);
So, my version process copies Current data (calculated on N: level) to new version. But I need C: rules to apply on new version consolidations to show percentage data properly. Thus I have rules divided on two parts like this:
C: rules, above
['IPR_quantity, %']=C:['No of accepted with insurance, ea']\['No of accepted accounts, ea.'];
below:
['IPR_quantity, %'] = N: ['No of accepted with insurance, ea']\['No of accepted accounts, ea.'];
So, my N: level calculated only for Current and Actual data, and C: rules applied all over the cube. I found following issue:
when new version is created, no C: rules applies to consolidations, but OLD versions works ok. When I restart TM1 server, C: rules start working.
What could be the reason? Is it possible to appply C: rules to new elements without restarting the server?
I have notised strange behaviour of my Cognos TM1 rules.
I have Versions dimension where new elements are added by rule. New verions has STET applied by following rule:
[] = N: IF(!Version@='Current' % !Version@='Actual', CONTINUE, STET);
So, my version process copies Current data (calculated on N: level) to new version. But I need C: rules to apply on new version consolidations to show percentage data properly. Thus I have rules divided on two parts like this:
C: rules, above
['IPR_quantity, %']=C:['No of accepted with insurance, ea']\['No of accepted accounts, ea.'];
below:
['IPR_quantity, %'] = N: ['No of accepted with insurance, ea']\['No of accepted accounts, ea.'];
So, my N: level calculated only for Current and Actual data, and C: rules applied all over the cube. I found following issue:
when new version is created, no C: rules applies to consolidations, but OLD versions works ok. When I restart TM1 server, C: rules start working.
What could be the reason? Is it possible to appply C: rules to new elements without restarting the server?