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.
Set Cube Security in TI
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- 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
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.
AFAIK there is no TI function CubeSecurityPut() or anything like that.
Kamil Arendt
-
- 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
I don't think you need it. Although I have never used it like this, the following syntax should work:qml wrote:AFAIK there is no TI function CubeSecurityPut() or anything like that.
ElementSecurityPut('WRITE', '}Cubes', CubeName, GroupName);
- 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
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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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
I'll try both methods then. I'll try CellPut first,
Jim.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7