Page 1 of 1

Rules in }ClientGroups cube

Posted: Tue May 20, 2025 11:23 pm
by hello123
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

Re: Rules in }ClientGroups cube

Posted: Wed May 21, 2025 9:25 am
by lotsaram
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.