TM1 Forum

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

Always put the N rule first.

diegoweichafe wrote:...even when they are being applied to different areas of the cube (N: and C: Level)...

From a TM1 terminology point of view, your rules are not applied to different areas. The definition of a rule is: The [Area] part of a rule is everything to the left hand side of the equals sign, so in your case the [Area] is the same. The N: and C: (or blank, or S: as appropriate) are Qualifiers that indicate what type of cells within the [Area] that the [Formula] applies to.

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: i.e. If you want to have the flexibility of two rules on separate lines repeating the ['Forecast Base', 'OCR'] then set AllowSeparateNandCRules to T (changing it will require a server restart). Obviously you need to understand how this may affect other rules in your system.

diegoweichafe wrote:...even when they are being applied to different areas of the cube (N: and C: Level)...

From a TM1 terminology point of view, your rules are not applied to different areas. The definition of a rule is: The [Area] part of a rule is everything to the left hand side of the equals sign, so in your case the [Area] is the same. The N: and C: (or blank, or S: as appropriate) are Qualifiers that indicate what type of cells within the [Area] that the [Formula] applies to.

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: i.e. If you want to have the flexibility of two rules on separate lines repeating the ['Forecast Base', 'OCR'] then set AllowSeparateNandCRules to T (changing it will require a server restart). Obviously you need to understand how this may affect other rules in your system.