TM1 Forum

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.

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.

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?

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.

thanks. Appreciate your help/support.