Hi All,
Thanks for your help,
really need to figure out this issue with TM1
as you can see in both pictures.. I'm applying a rule for C: and N: level that shouldn't affect each other..but somehow they do it... but if I change the order or comment out the lines the results change to... even when they are being applied to different areas of the cube (N: and C: Level)
I would really appreciate your help to know how to solve this issue
thanks you very much
Rule not working if I change the order
-
- Posts: 5
- Joined: Mon Sep 26, 2016 3:13 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 210
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Rule not working if I change the order
Always put the N rule first.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 351
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: Rule not working if I change the order
From a TM1 terminology point of view, your rules are not applied to different areas. The definition of a rule is:diegoweichafe wrote:...even when they are being applied to different areas of the cube (N: and C: Level)...
Code: Select all
[Area] = [Qualifier] [Formula];
Check the setting for AllowSeparateNandCRules in your config file. You'll probably find that this is either not present or set to F.
If this is the case and you don't want to change that, then you will need to use the extended format of the above:
Code: Select all
[Area] = N: [N level Formula]; C: [C level Formula];
Code: Select all
['Forecast Base', 'OCR'] = N: If(...); C: 1;
Andy Key
-
- MVP
- Posts: 351
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: Rule not working if I change the order
From a TM1 terminology point of view, your rules are not applied to different areas. The definition of a rule is:diegoweichafe wrote:...even when they are being applied to different areas of the cube (N: and C: Level)...
Code: Select all
[Area] = [Qualifier] [Formula];
Check the setting for AllowSeparateNandCRules in your config file. You'll probably find that this is either not present or set to F.
If this is the case and you don't want to change that, then you will need to use the extended format of the above:
Code: Select all
[Area] = N: [N level Formula]; C: [C level Formula];
Code: Select all
['Forecast Base', 'OCR'] = N: If(...); C: 1;
Andy Key