C rules does not apply to new dimension elements

Post Reply
Vadim
Posts: 2
Joined: Fri Aug 22, 2014 8:52 pm
OLAP Product: Cognos
Version: 10.2
Excel Version: 2007

C rules does not apply to new dimension elements

Post 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?
User avatar
gtonkin
MVP
Posts: 1265
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: C rules does not apply to new dimension elements

Post by gtonkin »

Which version of TM1 is being used? e.g. 10.2.2 FP2
BR, George.

Learn something new: MDX Views
Vadim
Posts: 2
Joined: Fri Aug 22, 2014 8:52 pm
OLAP Product: Cognos
Version: 10.2
Excel Version: 2007

Re: C rules does not apply to new dimension elements

Post 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.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: C rules does not apply to new dimension elements

Post 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
Declan Rodger
User avatar
gtonkin
MVP
Posts: 1265
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: C rules does not apply to new dimension elements

Post by gtonkin »

Please see the issue I had and was resolved in the later releases of 10.2.2 here
BR, George.

Learn something new: MDX Views
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: C rules does not apply to new dimension elements

Post 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
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
ardi
Community Contributor
Posts: 165
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: C rules does not apply to new dimension elements

Post by ardi »

Check the tm1s.cfg and make sure that you have this setting on

AllowSeparateNandCRules=T
Ardian Alikaj
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: C rules does not apply to new dimension elements

Post 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.
Declan Rodger
Post Reply