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 » Tue Nov 10, 2020 1:34 pm

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: 2588
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Security Import

Post by Wim Gielis » Tue Nov 10, 2020 1:42 pm

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Using TI to change elemant names, like Biden to Trump

Emixam
Posts: 85
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 » Tue Nov 10, 2020 3:43 pm

Or use the ElementSecurityPut function. This will create the }ElementSecurity_ cube if it's not already created.
Sorry for my English :)

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 » Wed Nov 11, 2020 7:18 am

Thanks for the replies

Post Reply