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.
Problem with rules and input data in Contributor
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Problem with rules and input data in Contributor
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.
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Re: Problem with rules and input data in Contributor
I think rule here isn't make much sense (I wrote different pieces of code). The problem here is Contributor behaviorDavid 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.
But if you want
SKIPCHECK;
[ ] = N: IF(!#test_Regions@<>'All Regions',Continue,STET);
[ ] = N: IF(['All Regions' ] <>0,['All Regions' ],STET);