APAR PI24861; C: Level rule overwrites N: Levels

Post bug reports and the status of reported bugs
Post Reply
User avatar
gtonkin
MVP
Posts: 438
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

APAR PI24861; C: Level rule overwrites N: Levels

Post by gtonkin » Wed Aug 27, 2014 3:01 am

Placing a C level rule below an N level rule interferes with the N level rules below that C level rule and can lead to data loss.

This is in spite of the fact that the parameter AllowSeparateNandCRules is set to T.

As an example if there is an element called Volume and the following rule is set it will cause the cells in the cube to have a status of not editable and can also lead to the loss of previously INPUT values:
['Volume']=N:IF(['Value']=0,0,CONTINUE);
['Volume']=C:0;
['Volume']=N:STET;


The STET command was added to prove the point that even if STET'ed, the C: rule overwrites - normally it would suffice to have the N Rule, continue, no other N Rules and cells would remain editable.

Cells in the cube viewer appear white and editable but their status in not editable. Trying to change their value results in a "data spread failed".

Changing the C: level rule to something other than zero shows that value at a C level but N levels are still affected.
Placing the C: level rule seems to work but who can say under what circumstances it won't.

This is definitely a bug and the attached model works as expected under 9.4, 9.5.2 and has been logged accordingly. Please be aware of the possible impact on your client's systems.

TM1 Version 10.2.2 - Windows, IBM SR42600689864

@MODS - please move this to the Bugs sub-forum as I do not have permissions to do so.
Attachments
Test_Data.zip
Sample model to test C Level overwriting N Level
(33.99 KiB) Downloaded 104 times
Last edited by gtonkin on Fri Aug 29, 2014 5:19 pm, edited 1 time in total.

lotsaram
MVP
Posts: 2952
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: 10.1 10.2
Excel Version: 2010 2013 365
Location: Switzerland

Re: SR42600689864; C: Level rule overwrites N: Levels

Post by lotsaram » Wed Aug 27, 2014 6:10 am

I can confirm that this is a definite bug in 10.2. I have come up against it in a few projects already. It can be worked around but only by rewriting rules by changing priority and putting in additional conditional tests. Needs to be fixed.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
gtonkin
MVP
Posts: 438
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: SR42600689864; C: Level rule overwrites N: Levels

Post by gtonkin » Fri Aug 29, 2014 5:18 pm

This issue has now been referred to Dev for fixing - APAR PI24861

User avatar
Alan Kirk
Site Admin
Posts: 5657
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: APAR PI24861; C: Level rule overwrites N: Levels

Post by Alan Kirk » Fri Oct 03, 2014 10:50 pm

This is claimed to be addressed in 10.2.2 FP1; anybody on 10.2 want to check and confirm?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
gtonkin
MVP
Posts: 438
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: APAR PI24861; C: Level rule overwrites N: Levels

Post by gtonkin » Mon Oct 06, 2014 12:10 pm

Just applied FP1 patch to test this issue - happy to report that TM1 behaves as it used to do.
I created a very simplistic example cube with Year, Month and Measures - Measures had Volume, Value, Extended to illustrate the issue.

Rules are as follows:

Code: Select all

SKIPCHECK;
['Volume']=N:IF(['Value']=0,0,CONTINUE);
['Extended']=N:['Value']*['Volume'];
['Volume']=C:9999;
FEEDERS;
['Value']=>['Extended'];
Assuming the view is set up with Measures on columns in Value, Volume, Extended order, you can now input Value, then Volume and recalc to get Extended.

Previously when you attempted to enter Volume, you would get Data Spread Failed.

BTW - the APAR is not noted in the Fix List but based on the problem described above and my test case, something has been fixed.

User avatar
gtonkin
MVP
Posts: 438
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: APAR PI24861; C: Level rule overwrites N: Levels

Post by gtonkin » Fri Oct 10, 2014 7:03 am

http://www-01.ibm.com/support/docview.w ... ab_1022FP1 is now showing that PI24861 is fixed in 10.2.2 FP1

Post Reply