Process Security

Post Reply
conray
Posts: 41
Joined: Thu Jul 07, 2011 7:50 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Excel 2010

Process Security

Post by conray »

Hi,

I have a end user process which calls a sub process.
Inside the sub process, there is a CellPutS code.

When end user runs the process, the sub process CellPutS code does not execute.
But if i run it as admin, the code works.

Question is, how can i overcome this without setting end user as admin?
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
declanr
MVP
Posts: 1831
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: Process Security

Post by declanr »

Right-Click on the process in server explorer and tick "Security Access", this needs to be done for any process which will change data in the security cubes and is going to be ran by a non-admin.

http://publib.boulder.ibm.com/infocente ... tyDat.html
Declan Rodger
conray
Posts: 41
Joined: Thu Jul 07, 2011 7:50 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Excel 2010

Re: Process Security

Post by conray »

what if the sub process would would CellPutS into the }CubeProperties cube?
Basically i am trying to lock a cube after finishing the whole process.
Is it doable?
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Process Security

Post by lotsaram »

conray wrote:what if the sub process would would CellPutS into the }CubeProperties cube?
Basically i am trying to lock a cube after finishing the whole process.
Is it doable?
What is the status of the cube BEFORE running the process? If it is locked prior then even admin access will not be able to write. Do you know you can just leave the cube locked and use the CubeLockOverride function in the TI to enable updating even while locked?
conray
Posts: 41
Joined: Thu Jul 07, 2011 7:50 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Excel 2010

Re: Process Security

Post by conray »

Status of the cube before process run is "Lock".
I didnt know about the CubeLockOverride function, this is exactly what i needed.
Tested and worked.
Thanks lotsaram.
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
Post Reply