Rules in }ClientGroups cube

Post Reply
hello123
Posts: 7
Joined: Fri Aug 03, 2012 1:54 pm
OLAP Product: TM1 Cognos
Version: 9.5.2
Excel Version: 2010

Rules in }ClientGroups cube

Post 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
lotsaram
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

Post 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply