Add an element to a control dimension with non-Admin user ID?

[syd]

Hello All,

Is there a way to add an element to }Groups dimension with non-admin/non-dataadmin user?

[PavoGa]

If you have a TI with security access checked, I think you can.

[syd]

It did not work.

==> Execution was aborted. No Security Access for "DimensionElementInsert".

[MarenC]

Hi,

You need to use the AddGroup function, not dimensionelementinsert.

Maren

[jim wood]

Moved to the correct forum.

[declanr]

Hi,

You need to use the AddGroup function, not dimensionelementinsert.

Maren

DimensionElementInsert or AddGroup will work; the }Groups dimension is a dimension just like any other.
Similar to how you can use CellPutS on the }ClientGroups cube instead of AssignClientToGroup - the difference is that the designated functions also "refresh" the security model by default; whereas if you use the standard functions you will need to run a SecurityRefresh function as well.

It did not work.

==> Execution was aborted. No Security Access for "DimensionElementInsert".

This specific error "No Security Access" occurs when a non-admin user runs a TI process that contains "ADMIN" activities.
You can get around this by right-clicking on the process and ticking "Enable Security Access".
With that enabled the process will allow non-admin users to run it and action the admin tasks within the process.

[MarenC]

Hi declan,

thanks for the info, but I decided to assume that they had enabled security access, given this was the advice provided by PavoGo. And I thought, well why not use AddGroups for this, maybe they are unaware of it...!

I was still expecting the error message to occur in all honesty, as I thought the issue was indeed that they had not bothered to follow the advice given (or didn't understand what was being hinted at).

Your advice is more specific, and probably more helpful!

Maren

[syd]

Hi,

You need to use the AddGroup function, not dimensionelementinsert.

Maren

DimensionElementInsert or AddGroup will work; the }Groups dimension is a dimension just like any other.
Similar to how you can use CellPutS on the }ClientGroups cube instead of AssignClientToGroup - the difference is that the designated functions also "refresh" the security model by default; whereas if you use the standard functions you will need to run a SecurityRefresh function as well.

It did not work.

==> Execution was aborted. No Security Access for "DimensionElementInsert".

This specific error "No Security Access" occurs when a non-admin user runs a TI process that contains "ADMIN" activities.
You can get around this by right-clicking on the process and ticking "Enable Security Access".
With that enabled the process will allow non-admin users to run it and action the admin tasks within the process.

I totally missed this Enabling the Security Access Option for a Process. After enabling this, it worked.