Cell Security rules in a cube
Posted: Tue Sep 24, 2019 3:35 pm
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.
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.