TM1 Forum

Hi
I have a req where in the below cube, user has to enter comment in 'edit comment' field. When ever higher official likes the comment, he has to enter 'Y' in Approve field so that comment from edit comment will be copied to Comment filed. I used the foll rule If user writes something in edit comment, as Approve has already Y in it, it directly goes to Comment field.
I want to gray out(non editable) the EditComment field when ever Y is typed in Approve field.
I tried to assign some rule so that it grays out if Approve is Y, But am getting error.

Rule is used Please Let me know if am confusing.

Thanks
Daya

['Edit Comment']=S:(IF(DB('Test Comment',!Test Date,!Test KRI,'Approve')@='Y',DB('Test Comment',!Test Date,!Test KRI,'Edit Comment'),STET));

This is a circular reference and you won't be able to make it work.

The other way to approach this is to use Cell Security to change the user's access from write to read once their comment has been approved. There's some discussion of that approach here: http://forums.olapforums.com/viewtopic.php?f=3&p=7441

Martin

Just replace the STET with CONTINUE and it will work fine. I've done this type of thing many times. A STET cancels the rule calculation but still leaves the rule on while a CONTINUE cancels the rule calculation and opens the cell for input.

Hi Martin

I tried to write a rule in Control cube But am getting an error. Rule: Error:

tomok wrote:Just replace the STET with CONTINUE and it will work fine. I've done this type of thing many times. A STET cancels the rule calculation but still leaves the rule on while a CONTINUE cancels the rule calculation and opens the cell for input.

@Tomok: I'm sure that after replacing STET with CONTINUE the rule won't work fine, as there is a circular reference in the rule, as Martin mentioned. Also your STET/CONTINUE explanation is the other way around - CONTINUE cancels the calculation of the current rule where the rules engine will continue to look for another applicable rule, while STET cancels the calculation and opens the cell for input...

@daya007: What happens if you replace the STET in your security rule with 'WRITE'?

Michel

@ Michel

I tried using 'Write', but same error repeating.

@Tomok

I tried using Continue, but dint make difference.

Hi, I was sleeping here...
The problem is that the dimensions Test Date and Test KRI are unknown in the control cube.
So you can't use those as a variable.

Michel

As Martin mentioned, you need cell security here - not dimension security.

Michel

Got it...Thanks All....