is cell data being deleted by overriding by rules?

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

is cell data being deleted by overriding by rules?

Post by ioscat »

is cell data being deleted by overriding by rules?
when we apply rule to a cell usually data in cell turns to space. today i got very strange behaviour of my tm1. i put a rule for cell:

Code: Select all

skipcheck;
['measure1']=N:if(!month@='jan',120,0)
well, firstly it normally aggregated like it was feeded properly. secondly, when i switched rule off - previous (manually input data) recovered.
What may be the reason?
asutcliffe
Regular Participant
Posts: 164
Joined: Tue May 04, 2010 10:49 am
OLAP Product: Cognos TM1
Version: 9.4.1 - 10.1
Excel Version: 2003 and 2007

Re: is cell data being deleted by overriding by rules?

Post by asutcliffe »

I think the precise behaviour depends on your version. At least on my 9.5.2 setup, applying a rule to a cell does delete any data in the cell. In earlier versions, the opposite was true.
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: is cell data being deleted by overriding by rules?

Post by Wim Gielis »

Hello asutcliffe

It sure depends on version, but IIRC in versions 9.1 or 9.4, I could have a rule like:

['2012']=N:0;

to erase 2012's data in a certain cube.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: is cell data being deleted by overriding by rules?

Post by ioscat »

well, i thought exactly as you, but i was extremely confused when got this "bug-feature".
Post Reply