TM1 Forum

I have a cube in Contributor where users input data.
Also where is a rule in the Cube

The idea of rule - when you input data in one of elements (All Regions) this data spreading around other elements. But if you input zero into the element All Regions you can input data in the other elements The problem is when
1. the user at first inputted data in All Regions (they spread through other Regions)
2. When user click Commit (green tick)
3. After it the user input zero in All Regions

Here Regions are releasing from the rule and it seems the user can input data in Region1 or Region2 but alas:
Contributor shows Error message (that the rules are using in the cell)

It seems that although Contributor shows that rules don't do for the cell, TM1 server doesn't think so.

Then you click Commit again this problem is solved.

But may be you can give me other ideas how to avoid this problem.

Don't think you'll get much help unless you post the rule, ideally with the PM cruft removed so forumers can see what's going on.

David Usherwood wrote:Don't think you'll get much help unless you post the rule, ideally with the PM cruft removed so forumers can see what's going on.

I think rule here isn't make much sense (I wrote different pieces of code). The problem here is Contributor behavior
But if you want
SKIPCHECK;
[ ] = N: IF(!#test_Regions@<>'All Regions',Continue,STET);
[ ] = N: IF(['All Regions' ] <>0,['All Regions' ],STET);