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.
Cell Security rules in a cube
-
- 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
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) ?
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
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