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
Lock cell temporarily
- 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
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.
Also you can create a Active Button to execute your TI Process.
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- 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
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
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
-
- 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
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 wrote:I tried ElementSecurityPut, but the user who executes the process must have data security rights, which the normal user does not have.
-
- 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
Great, thanks a lot!