Help on Rule in }ElementSecurity_Dimension

Post Reply
Paul-TM1
Posts: 124
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 1987 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: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
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
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