Security to allow user to add elements to Dim

[tosca1978]

Hi all,

I'm working in excel 2007 and TM1 9.5.2.

Hopefully a quick one for you! I have tried searching for an answer already but cannot find what I'm looking for.

I have created a TM1 worksheet to enable end users to create new elements in a dimension. Parameters are passed to the TI that create the new element etc. During testing it all works fine for the Admin user group but not for the end user group. The process fails.

My question is - what security do I need to give the end user group to allow them to add an element?

When I right click on dimensions/security assignments the user group has WRITE access to the dimension in question.
When I right click on security/Element Security Assignments (for the dim in question) the user group has write access to all elements within the dim.

I have not created any control cubes like Element Security / dimension security etc. But then I didn't think that I needed to create these to achieve what I want here.

Any help would be much appreciated.

Cheers

[Steve Vincent]

TIs do not take in to account the security of the user running it when it carries out its actions (loading data, editing dims etc), so the security you have set isn't going to make any difference. The TI will always run as "ADMIN" no matter who executes it, but a user must also have the security rights to RUN the TI.

If you right click Processes and select Security Assignments, the TI will need the user group in question to have READ access. This should then allow the users to run the TI and edit the dimension. Its explained in the "Developers Guide" installed with TM1, although not very well

[tosca1978]

Steve,

thanks very much for you're reply. I did as you said and it now works perfectly for the end user group.

Thanks again!

[PlanningDev]

FYI you may want to remove write access for that group to the dimension. If im remembering correctly, WRITE access to a dimension allows users to modify public subsets.