How to prevent any TI process writing to cells which are set to READ

Post Reply
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

How to prevent any TI process writing to cells which are set to READ

Post by Ashleigh W »

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.
Wim Gielis
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

Post by Wim Gielis »

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.
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
Ashleigh W
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

Post by Ashleigh W »

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?
Wim Gielis
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

Post by Wim Gielis »

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.
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
Ashleigh W
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

Post by Ashleigh W »

thanks. Appreciate your help/support.
Post Reply