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
TM1 Security Import
-
- 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
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
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
-
- 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
Or use the ElementSecurityPut function. This will create the }ElementSecurity_ cube if it's not already created.
-
- Posts: 6
- Joined: Wed Nov 04, 2020 10:05 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 Security Import
Thanks for the replies