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.
Help on Rule in }ElementSecurity_Dimension
-
- MVP
- Posts: 3113
- 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
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
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
-
- 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
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') ;
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') ;