Page 1 of 1
Add an element to a control dimension with non-Admin user ID?
Posted: Wed Mar 22, 2023 2:20 pm
by syd
Hello All,
Is there a way to add an element to }Groups dimension with non-admin/non-dataadmin user?
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Wed Mar 22, 2023 2:59 pm
by PavoGa
If you have a TI with security access checked, I think you can.
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Wed Mar 22, 2023 4:18 pm
by syd
It did not work.
==> Execution was aborted. No Security Access for "DimensionElementInsert".
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Wed Mar 22, 2023 5:35 pm
by MarenC
Hi,
You need to use the AddGroup function, not dimensionelementinsert.
Maren
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Wed Mar 22, 2023 5:36 pm
by jim wood
Moved to the correct forum.
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Wed Mar 22, 2023 9:14 pm
by declanr
MarenC wrote: ↑Wed Mar 22, 2023 5:35 pm
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.
syd wrote: ↑Wed Mar 22, 2023 4:18 pm
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.
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Thu Mar 23, 2023 7:50 am
by 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
Re: Add an element to a control dimension with non-Admin user ID?
Posted: Thu Mar 23, 2023 2:27 pm
by syd
declanr wrote: ↑Wed Mar 22, 2023 9:14 pm
MarenC wrote: ↑Wed Mar 22, 2023 5:35 pm
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.
syd wrote: ↑Wed Mar 22, 2023 4:18 pm
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.