TM1 Forum

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? 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.

You can use the function ELISANC in the rule to determine the relations between the elements, and hence give READ access.

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') ;