Hello All,
Is it anyhow possible to implement security in a dimension based on attribute value of an element? For Example:
Dimension Element Attribute
L1 SPI
L2 REG
L3 OPF
L4 SPI
L5 SPI
L6 OPF
Now what i want, a user tagged with SPI must have access of L1, L4 and L5 and a user tagged with OPF, must have access of L3 and L6.
Please let me know how we can tag a user with an attribute value of elements in a dimension.
Any help would be greatly appreciated.
Thanks,
Manoj
Security in a dimension based on attribute
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Security in a dimension based on attribute
Yes, you just need to write a rule in the }elementsecurity_'dimension' cube.manoj928 wrote:Hello All,
Is it anyhow possible to implement security in a dimension based on attribute value of an element? For Example:
Dimension Element Attribute
L1 SPI
L2 REG
L3 OPF
L4 SPI
L5 SPI
L6 OPF
Now what i want, a user tagged with SPI must have access of L1, L4 and L5 and a user tagged with OPF, must have access of L3 and L6.
Please let me know how we can tag a user with an attribute value of elements in a dimension.
Any help would be greatly appreciated.
Thanks,
Manoj
[]=S:
If ( Attrs ( 'Dimension', !Dimension, 'Attribute' ) @= !}Groups, 'WRITE', 'READ' );
Declan Rodger