ElementSecurityPut() function
-
- Posts: 27
- Joined: Wed Mar 06, 2013 2:48 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
ElementSecurityPut() function
Hi All,I want to assign different level of security to multiple securtiy groups at once or dynamically.I am using ElementSecurityPut TI function but i think its limitation is it assigns security of one group at once.Can i make it dynamic to assign different level of security to multiple groups and for multiple dimension and elements.Thanks in advance.
- 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: ElementSecurityPut() function
You put rules in place on security cubes once they exist. So yes you can dynamically assign security. The only down side is you need to refresh security. ElementSecurityPu is limited in the same way that CellPutS is limited. Security is cube based hence it doing 1 group at a time a time as it is effectively writing a value to a cube. I hope that helps,
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
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: ElementSecurityPut() function
Do you have to run a security refresh with ElementSecurityPut? Or is that only if you manually change a security cube/ or have rule derived security?
- 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: ElementSecurityPut() function
If you use ElementSecurityPut you don't have to refresh security. (As far as I remember. It's been a while.)
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