Chore that write to Security Cubes

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Chore that write to Security Cubes

Post by appleglaze28 »

Just a quick question...are chores that requires writing to a security cube restricted from being done? Cause I assume that chores are ran as a Admin User so when it run it should update the security cubes...but how come...it says that Data Source line (1) Error: Data procedure line (8): Execution was aborted. No Security Access for "CellPutS".

The process reads the attribute of a dimension to determine which groups have WRITE Access on that dimension.

What can be my alternate solution to do this without depending on the admin.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Chore that write to Security Cubes

Post by qml »

You need to switch on Security Access for the process(es) that attempt to make any security changes. More on the subject here:
http://publib.boulder.ibm.com/infocente ... tyDat.html
Kamil Arendt
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Chore that write to Security Cubes

Post by lotsaram »

Yet again appleglaze28 you have astounded me. You needn't look so far as the IBM library but at the answer to your own question posted not so long ago.

http://www.tm1forum.com/viewtopic.php?f=3&t=3919

(Note to site admins: this question comes up an awful lot, should probably add it to processes and/or security section of FAQ)
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: Chore that write to Security Cubes

Post by Alan Kirk »

lotsaram wrote:Yet again appleglaze28 you have astounded me. You needn't look so far as the IBM library but at the answer to your own question posted not so long ago.

http://www.tm1forum.com/viewtopic.php?f=3&t=3919

(Note to site admins: this question comes up an awful lot, should probably add it to processes and/or security section of FAQ)
Yeah, but is it ever asked by more than one person? :?

Duly noted; I'll gather up links to the relevant threads and documents when I have a moment.
"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.
Post Reply