TM1 Forum

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

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