Lock cell temporarily

Post Reply
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Lock cell temporarily

Post by Toto »

Hello,

I would like to make my own little workflow. Until a user presses a button, some cell should not be editable for him. After pressing the button he should be able to edit the cells, until he presses the button again.
Should this be done within a TI-process, or is it better to have rules for it?
How should this rule look like (have not found the function for locking a cell yet)?
For the TI process I would use ElementSecurityPut, right?

Thanks a lot for a hint!

Regards,

Toto
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Lock cell temporarily

Post by rkaif »

Yes you can use ElementSecurityPut() function in the TI Process to make the cells Read only. You can also use the same function to unlock the cells and give Write security level.

Also you can create a Active Button to execute your TI Process.
Cheers!
Rizwan Kaif
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Re: Lock cell temporarily

Post by Toto »

Hello Rizwan,

thanks for your reply. I tried ElementSecurityPut, but the user who executes the process must have data security rights, which the normal user does not have.
In my TM1Web-Frontend the user should press a button like "Start the task" and only after pressing the button he should be able to insert the data for the task.

Any idea what should happen in the background when pressing the button?

Thanks a lot!!

Toto
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Lock cell temporarily

Post by lotsaram »

Toto wrote:I tried ElementSecurityPut, but the user who executes the process must have data security rights, which the normal user does not have.
You need to ensure that the "Security Access" option for the process is checked (to do this right-click the process name). Then you just need to give a group the user belongs to read access to the process in question.
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Re: Lock cell temporarily

Post by Toto »

Great, thanks a lot!
Post Reply