Help on Rule in }ElementSecurity_Dimension

Post Reply
Paul-TM1
Posts: 139
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Help on Rule in }ElementSecurity_Dimension

Post by Paul-TM1 »

Hi,
I want to write a rule to apply 'READ' access to all the descendants of a hierarchy and direct ancestors above to cover the lineage on }ElementSecurity_Dimension.
Can anyone help me? I tried a few ways and don't seem to get it. I can write a TI, but is that the best solution?
ElementSecurity.PNG
ElementSecurity.PNG (21.33 KiB) Viewed 2318 times
In the picture attached, if I want to give access to descendants of 'Benelux' and also immediate ancestors (Europe and World). Our Dimension has many children than the attached dimension.

Thanks,
Paul.
Wim Gielis
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: Help on Rule in }ElementSecurity_Dimension

Post by Wim Gielis »

You can use the function ELISANC in the rule to determine the relations between the elements, and hence give READ access.
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
tm123
Posts: 132
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

Re: Help on Rule in }ElementSecurity_Dimension

Post by tm123 »

You can try something like below.

I try to hardcode element names in Rules so you might have to use some mapping cube or dimension attributes to map Regions to User Groups

[ 'Group_Name' ] = S: IF ( ELISANC('DimName', !DimName, 'Benelux') = 1 % ELISANC('DimName', 'Benelux', !DimName ) = 1 % !DimName @= 'Benelux' , 'READ', 'NONE') ;
Post Reply