Help on Rule in }ElementSecurity_Dimension

Post Reply
Posts: 37
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 » Mon Apr 09, 2018 3:40 pm

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 (21.33 KiB) Viewed 248 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.


Wim Gielis
Posts: 1733
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium

Re: Help on Rule in }ElementSecurity_Dimension

Post by Wim Gielis » Mon Apr 09, 2018 3:47 pm

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

Excel Most Valuable Professional, 2011-2014 ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Posts: 110
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 » Mon Apr 09, 2018 4:00 pm

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