Problem with rules and input data in Contributor

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Problem with rules and input data in Contributor

Post by EP_explorer »

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.
02.JPG
02.JPG (13.97 KiB) Viewed 2343 times
But if you input zero into the element All Regions you can input data in the other elements
03.JPG
03.JPG (13.21 KiB) Viewed 2343 times
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.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Problem with rules and input data in Contributor

Post by David Usherwood »

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.
EP_explorer
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

Post by EP_explorer »

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);
Post Reply