Cell Security rules in a cube

Post Reply
Nidhik
Posts: 5
Joined: Thu Jun 20, 2019 1:08 am
OLAP Product: TM1
Version: 2.0.37
Excel Version: 365

Cell Security rules in a cube

Post by Nidhik »

Hi All,
We have special cell security rules in our P&L finance cube for stat accounts to be able to update Actual and Fcst. It is not ideal as people move jobs and roles.

How do others manage the security using common "Center" dimension Security cube irrespective of accounts dimension? An example is below rule that is part of cell security in the cube where request for adding more users are coming in as new employees are joining. Also what is the syntax to add another user id here?

['User_eptt0nl'] = S:

IF(ELISANC('bpmAccountIS','Dora Pharmacy Metrics',!bpmAccountIS) = 1,


);
Thanks.
Wim Gielis
MVP
Posts: 3234
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: Cell Security rules in a cube

Post by Wim Gielis »

I am probably not understanding you, but do you have a dimension of users here ?
You are aware that security in TM1 is organized with groups, rather than users (who can come and go) ?
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
Post Reply