Hello again Experts, Community,
How to prevent any TI process writing to cells which are set to READ security.
I understand that for TI Processes that are under my control can be set/coded logically but I'm looking for solution that irrespective of TI Process/Manual Input I want to prevent alteration of values in cells which are READ.
Thanks in advance.
How to prevent any TI process writing to cells which are set to READ
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
-
- MVP
- Posts: 3233
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: How to prevent any TI process writing to cells which are set to READ
You need to code it in the TI process itself.
For example, for the TM1User() executing the process, retrieve the groups that he/she is part of.
For all groups, determine what the exact rights are with respect to the cell.
Or, don't make life too difficult: you can create a small lookup cube with Scenario / Version / Year / Period / ... to indicate if the period is closed or not. Then do a CellGetS in your process and proceed depending on the result you have.
For example, for the TM1User() executing the process, retrieve the groups that he/she is part of.
For all groups, determine what the exact rights are with respect to the cell.
Or, don't make life too difficult: you can create a small lookup cube with Scenario / Version / Year / Period / ... to indicate if the period is closed or not. Then do a CellGetS in your process and proceed depending on the result you have.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: How to prevent any TI process writing to cells which are set to READ
Hi Wim, thanks for prompt response.
That's very useful tip. Is there a way to prevent some other unknown TI process write/edit these cells when locked?
That's very useful tip. Is there a way to prevent some other unknown TI process write/edit these cells when locked?
-
- MVP
- Posts: 3233
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: How to prevent any TI process writing to cells which are set to READ
You are mixing up a few things.
Locked elements will block TI.
Other than that, you really need to code it yourself. For example with a generic process that is called from a number of other (master) processes.
Locked elements will block TI.
Other than that, you really need to code it yourself. For example with a generic process that is called from a number of other (master) processes.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: How to prevent any TI process writing to cells which are set to READ
thanks. Appreciate your help/support.