Security in a dimension based on attribute

Post Reply
manoj928
Posts: 60
Joined: Thu Mar 17, 2011 2:13 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.1
Excel Version: 2010

Security in a dimension based on attribute

Post by manoj928 »

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
declanr
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

Post by declanr »

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
Yes, you just need to write a rule in the }elementsecurity_'dimension' cube.

[]=S:
If ( Attrs ( 'Dimension', !Dimension, 'Attribute' ) @= !}Groups, 'WRITE', 'READ' );
Declan Rodger
Post Reply