Hi All,
Can we write rules in }ClientGroups cube?
I have written below rule, but it does not provide required access to the user.
The rule calculates correctly. e.g. it does update 'ADMIN' in the }ClientGroups cube for user X, but does not provide admin rights to the user X
[]=S: IF(DB('Cube1',ATTRS('}Clients',!}Clients,}TM1_DefaultDisplayValue),!}Groups)@<>'',!}Groups,STET);
Am I doing anything wrong or is the client assignment to group not allowed.
Note: I am using Planning Analytics 2.1
Thanks in advance.
Regards,
Lin
Rules in }ClientGroups cube
-
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Rules in }ClientGroups cube
Like any time using rules in security cubes the rule calculated values will only take effect after performing a security refresh function.
Rules in security cubes (with the exception of cell security) is not normally seem as a good practice and not generally recommended.
Rules in security cubes (with the exception of cell security) is not normally seem as a good practice and not generally recommended.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.