ElementSecurityPut() function

Post Reply
TM1ethusiast
Posts: 27
Joined: Wed Mar 06, 2013 2:48 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

ElementSecurityPut() function

Post by TM1ethusiast »

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.
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: ElementSecurityPut() function

Post by jim wood »

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.
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
PlanningDev
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

Post by PlanningDev »

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?
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: ElementSecurityPut() function

Post by jim wood »

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
Post Reply