TM1 Security Import

Post Reply
vvsreddy
Posts: 6
Joined: Wed Nov 04, 2020 10:05 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

TM1 Security Import

Post by vvsreddy »

Hi,

Need help in importing security from a csv file and assign the groups at element level using a TI.
I have a requirement of creating new groups (All users will be assigned to new groups - 1 user per group). After creating the groups, i am thinking of having a below CSV file imported into the system via a process across the element hierarchy and assigning the access to group.

Element Name1 New_Group1 READ
Element Name1 New Group2 WRITE

Regards,
vvsreddy
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Security Import

Post by Wim Gielis »

It's nothing more than a CellPutS in the right cell of the right }ElementSecurity_ cube...
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Emixam
Regular Participant
Posts: 156
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: TM1 Security Import

Post by Emixam »

Or use the ElementSecurityPut function. This will create the }ElementSecurity_ cube if it's not already created.
vvsreddy
Posts: 6
Joined: Wed Nov 04, 2020 10:05 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: TM1 Security Import

Post by vvsreddy »

Thanks for the replies
Post Reply