Help on Rule in }ElementSecurity_Dimension

[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 (21.33 KiB) Viewed 2317 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]

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

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