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

Post Reply
syd
Posts: 20
Joined: Tue Jan 21, 2014 2:03 am
OLAP Product: PA/TM1, CX
Version: PA 2.0
Excel Version: MSO 365

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

Post by syd »

Hello All,

Is there a way to add an element to }Groups dimension with non-admin/non-dataadmin user?
Thank you,
syd
User avatar
PavoGa
MVP
Posts: 618
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

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

Post by PavoGa »

If you have a TI with security access checked, I think you can.
Ty
Cleveland, TN
syd
Posts: 20
Joined: Tue Jan 21, 2014 2:03 am
OLAP Product: PA/TM1, CX
Version: PA 2.0
Excel Version: MSO 365

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

Post by syd »

It did not work.

==> Execution was aborted. No Security Access for "DimensionElementInsert".
Thank you,
syd
MarenC
Regular Participant
Posts: 358
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

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

Post by MarenC »

Hi,

You need to use the AddGroup function, not dimensionelementinsert.

Maren
User avatar
jim wood
Site Admin
Posts: 3952
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

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

Post by jim wood »

Moved to the correct forum. :)
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
declanr
MVP
Posts: 1816
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

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

Post 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.
Declan Rodger
MarenC
Regular Participant
Posts: 358
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

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

Post 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
syd
Posts: 20
Joined: Tue Jan 21, 2014 2:03 am
OLAP Product: PA/TM1, CX
Version: PA 2.0
Excel Version: MSO 365

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

Post 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.
Thank you,
syd
Post Reply