Page 1 of 1

C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 9:07 am
by Vadim
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?

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 9:34 am
by gtonkin
Which version of TM1 is being used? e.g. 10.2.2 FP2

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 10:03 am
by Vadim
gtonkin wrote:Which version of TM1 is being used? e.g. 10.2.2 FP2
TM1.Server TM1 Build Number: 10.2.00000.36339
I don't know if FP is applied.

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 10:10 am
by declanr
Vadim wrote: TM1.Server TM1 Build Number: 10.2.00000.36339
I don't know if FP is applied.
I believe that is the very base 10.2 version; either way what you describe is very much a bug and should be logged with IBM... but if you are on the 10.2 base install then it was full of holes and an update of the software would be recommended.

I actually do seem to remember a few issues being mentioned with C level rules etc in the early days of 10.2

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 10:23 am
by gtonkin
Please see the issue I had and was resolved in the later releases of 10.2.2 here

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 12:47 pm
by lotsaram
declanr wrote:
Vadim wrote: TM1.Server TM1 Build Number: 10.2.00000.36339
I don't know if FP is applied.
I believe that is the very base 10.2 version; either way what you describe is very much a bug and should be logged with IBM... but if you are on the 10.2 base install then it was full of holes and an update of the software would be recommended.

I actually do seem to remember a few issues being mentioned with C level rules etc in the early days of 10.2
I can only second that. If you are on 10.2.0 then you need to without question upgrade to 10.2.2

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 3:23 pm
by ardi
Check the tm1s.cfg and make sure that you have this setting on

AllowSeparateNandCRules=T

Re: C rules does not apply to new dimension elements

Posted: Wed Jun 10, 2015 8:20 pm
by declanr
ardi wrote:Check the tm1s.cfg and make sure that you have this setting on

AllowSeparateNandCRules=T
Normally that would be a good first bet for a question about C level rules not working but the OP mentioned that it works for old elements in the version dimension. As the parameter applies globally it would be an all or nothing issue.