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?
Process Security
-
- Posts: 41
- Joined: Thu Jul 07, 2011 7:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Excel 2010
Process Security
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
-
- 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
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
http://publib.boulder.ibm.com/infocente ... tyDat.html
Declan Rodger
-
- Posts: 41
- Joined: Thu Jul 07, 2011 7:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Excel 2010
Re: Process Security
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?
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
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
-
- 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
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 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?
-
- Posts: 41
- Joined: Thu Jul 07, 2011 7:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Excel 2010
Re: Process Security
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.
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
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010