TM1 Forum

Posted: **Thu Dec 06, 2012 1:16 pm**

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?

Posted: **Thu Dec 06, 2012 2:03 pm**

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.

Posted: **Thu Dec 06, 2012 2:05 pm**

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.

Posted: **Thu Dec 06, 2012 2:15 pm**

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

TM1 Forum

is cell data being deleted by overriding by rules?

is cell data being deleted by overriding by rules?

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

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

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