TM1 Forum

Hello, I'm trying to prevent users entering data into the wrong accounts. I want to do something like if Org is 800 then accounts that start with 8* are editable. Anything else would be greyed out/read only. And then something like if Org is 700 then accounts that start with 7* are editable. I'm not sure where this is done in TM1. I have been trying in the Cube Rules, but I am having no luck. Any help would be appreciated.

Thank you

What you are looking at is }CellSecurity.
Here's a useful link but there is a lot more: https://exploringtm1.com/cell-security- ... ete-guide/

I tried the code that was in the doc you sent. It failed when I tried to run it in a TI. I am assuming it is because there is a security cube already there. But the one there doesn't have the same dimensions, which I thought was weird.

Also, why wouldn't I put code in the rules of the cube? I see when Actuals come in, the past data. Those cells are greyed out. So I am trying to do the same, but with different logic.

The cell security cube can contain all dimensions of the base (application) cube but also less. Not every such dimension has to be part of the cell security cube.

Go and look for such a cube. You will find rules and then you can investigate / add lore rules.