Same rules within the cube

Post Reply
Posts: 12
Joined: Thu Apr 12, 2018 9:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Same rules within the cube

Post by lax9 » Tue Jun 05, 2018 9:07 pm

Hi All,

Can anyone help me out with the below issue:

We have a below rule (working) in the rule file.
Old rule
['xxx'] = N:
- ['ALL', 'Ending Balance']
+ ['ALL', 'Opening Balance']
+ ['old account'];

New rule
['xxx'] = N:
- ['ALL', 'Ending Balance']
+ ['ALL', 'Opening Balance']
+ ['updated account'];

same rule but with updated account in the new rule.
The issue is 'xxx' is calculation anything for the updated account in the CAFE

Please let me know if you need more info.

Thank you!

Posts: 1592
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

Re: Same rules within the cube

Post by declanr » Tue Jun 05, 2018 9:29 pm

Do you mean that the cells in question now have no rules applied to them? As in the cell can be edited by typing into it?

If so and the rule has only changed as you show to pull from 1 account instead of another then I would expect it is due to its position in the rule file and there is probably a STET statement applying to those same cells higher up the rule file (meaning it will take precedent.)

By the way you mention its not working in cafe, I would recommend not doing rule checks in cafe/pax but instead using architect, as the rule should be the same across all interfaces but architect has better tools for development purposes - get it working there and it will work in cafe as well.

Post Reply