Admin rights for one cube only for a specific user

Post Reply
nickykolle
Posts: 1
Joined: Fri Apr 23, 2010 9:10 am
OLAP Product: TM1
Version: 9.1
Excel Version: Excel 2007

Admin rights for one cube only for a specific user

Post by nickykolle »

Is it possible to create Admin rights for one cube only, for a specific user?
I tried creating a rule in the cell security cube, but didn't seem to work.
['User']=S:["Admin"]

How does one do this? I primarily want the user to be able to add members to a dimension.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Admin rights for one cube only for a specific user

Post by Alan Kirk »

nickykolle wrote:Is it possible to create Admin rights for one cube only, for a specific user?
I tried creating a rule in the cell security cube, but didn't seem to work.
['User']=S:["Admin"]

How does one do this? I primarily want the user to be able to add members to a dimension.
You can allow the user to be able to do that if you create a TI process which they can run, whether from within Server Explorer or via an action button. Essentially, you allow the TI to do the addition by passing it the new elements as parameters.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: Admin rights for one cube only for a specific user

Post by LoadzaGrunt »

I primarily want the user to be able to add members to a dimension.
Right click on dimensions in Server Explorer and pick 'Security Assignments...'. You can then give a group 'Admin' privelege on a dimension. When users that are members of this group log in they should be able to 'Edit Dimension Structure' and add and remove elements. IIRC that user could also use XDI dimension worksheets.
Post Reply