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?
C rules does not apply to new dimension elements
- 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
Which version of TM1 is being used? e.g. 10.2.2 FP2
-
- 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
TM1.Server TM1 Build Number: 10.2.00000.36339gtonkin wrote:Which version of TM1 is being used? e.g. 10.2.2 FP2
I don't know if FP is applied.
-
- 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
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.Vadim wrote: TM1.Server TM1 Build Number: 10.2.00000.36339
I don't know if FP is applied.
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
- 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
Please see the issue I had and was resolved in the later releases of 10.2.2 here
-
- 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
I can only second that. If you are on 10.2.0 then you need to without question upgrade to 10.2.2declanr wrote: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.Vadim wrote: TM1.Server TM1 Build Number: 10.2.00000.36339
I don't know if FP is applied.
I actually do seem to remember a few issues being mentioned with C level rules etc in the early days of 10.2
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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
Check the tm1s.cfg and make sure that you have this setting on
AllowSeparateNandCRules=T
AllowSeparateNandCRules=T
Ardian Alikaj
-
- 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
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.ardi wrote:Check the tm1s.cfg and make sure that you have this setting on
AllowSeparateNandCRules=T
Declan Rodger