TM1 Forum

Hello guys,

I don't understand why, but when I remove a rule on my cube, the scope which was previously calculated by the rule is populated with 0 values.
Dont know if there is a link but I use in my rule the Undefvals function.

Thanks in advance for your help !

Guillaume

I think I get what you're asking. (Your question is a bit cryptic) All rule values are virtual, remove the rules, remove the values. If you are expected values that existed before you put the rule in place to come through then that will depend on your version. There have been some discussions on this lately if you do a search,

Jim.

It is always helpful if in your post you can state which version of TM1 you are using, as quite often the behaviour that you are asking about can change between versions.

In this case what you are seeing is the behaviour that, on loading the cube, writes 0 values to the cells that are calculated. In version 10.1 this behaviour can be controlled with the configuration parameter RulesOverwriteCellsOnLoad.

I do not believe that your use of UNDEFVALS is contributing to this. However you should be aware that if you use UNDEFVALS in a rule and then either remove it or delete the rule then its effect persists until the server is shut down and restarted.

Think the answer might be a bit simpler
TM1 calculates on demand. Rule calculated values need the rules to be present. Take the rules away, no calculated values.

Thanks for your answers guys !

My conf is:
Server: Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2
Client: Windows XP.

So I can't use the RulesOverwriteCellsOnLoad parameter , but thanks, I will keep it in mind when we will upgrade the system.

I've omitted to say that the scope imapcted by my rule was totally empty before I set then remove the rule. So it can't be old values existing before I put the rule.

This morning, after a server restart, it seems that the zero values have disapeared !