Can anyone tell me whether TM1 can assign security at attribute level? I know how to assign security access to element in a dimension, but what if I would like to give the user write access against a particular element, but don't want the user to see the attributes of that element, is that possible?
For example, I have an employee dimension which contains all employee names as elements. Attributes attached to each employee elements are their respective date of birth and contract type with the company. I don't want the user to see those information, but I want them to have write access against those elements. Is this possible.
Your feedback or thoughts are greatly appreciated.
Attribute Security
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Attribute Security
You could set element security against the }ElementAttributes_Employee dimension or set cell security for the }ElementAttributes_Employee cube.
However I think you would be better off storing your attributes in either a custom lookup cube or else create a replica employee dimension for holding the attribute data.
However I think you would be better off storing your attributes in either a custom lookup cube or else create a replica employee dimension for holding the attribute data.
-
- Posts: 2
- Joined: Fri Jan 21, 2011 5:41 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
Re: Attribute Security
Thanks for the quick response. I set up the security access to "NONE" to all element in the }CellSecurity_}ElementAttribute_Employee, but still with no avail. Log in as a user, seems to me they still can see the attribute.
But thanks for the suggestion of setting up a dummy dimension for the purpose to store attributes.
But thanks for the suggestion of setting up a dummy dimension for the purpose to store attributes.