Set Cube Security in TI

Post Reply
User avatar
jim wood
Site Admin
Posts: 3961
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:

Set Cube Security in TI

Post by jim wood »

Guys,

I have been able to set element security within TI but I can't find a command to set sube security for groups wihtin in TI. Is this possible. I'm using a subset of the security groups as the source for TI,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: Set Cube Security in TI

Post by qml »

Why don't you try using CellPutS to write straight to the }CubeSecurity cube?

AFAIK there is no TI function CubeSecurityPut() or anything like that.
Kamil Arendt
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Set Cube Security in TI

Post by tomok »

qml wrote:AFAIK there is no TI function CubeSecurityPut() or anything like that.
I don't think you need it. Although I have never used it like this, the following syntax should work:

ElementSecurityPut('WRITE', '}Cubes', CubeName, GroupName);
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
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: Set Cube Security in TI

Post by jim wood »

I'll try that tomok thanks. I don't want to use either rules or writing directly to the control cubes as both of them requires a security refresh. With the model I'm working on that would mean too much down time,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: Set Cube Security in TI

Post by Alan Kirk »

jim wood wrote:I'll try that tomok thanks. I don't want to use either rules or writing directly to the control cubes as both of them requires a security refresh. With the model I'm working on that would mean too much down time,

Jim.
It's not been my experience that writing directly to the security cubes requires a security refresh; indeed that's the way that I usually manage it. The only time I've had to do that is for the one dimension which has security set by rules. If I change the rules, I need to do a refresh. If I punch the values into the cells on non-rules-based cubes, I don't; it takes effect immediately.
"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.
User avatar
jim wood
Site Admin
Posts: 3961
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: Set Cube Security in TI

Post by jim wood »

I'll try both methods then. I'll try CellPut first,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply