Search found 6 matches

by vvsreddy
Wed Nov 11, 2020 4:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security
Replies: 1
Views: 250

TM1 Security

Hi, We are currently having multiple groups, and after multiple discussions, client has decided to have individual groups for the users. Now, we have a requirement to copy the element access from old groups to the new groups. Imagine there is a user 'abc', now the new group for user will be G_abc. S...
by vvsreddy
Wed Nov 11, 2020 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security Import
Replies: 3
Views: 511

Re: TM1 Security Import

Thanks for the replies
by vvsreddy
Tue Nov 10, 2020 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security Import
Replies: 3
Views: 511

TM1 Security Import

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 syst...
by vvsreddy
Mon Nov 09, 2020 6:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security Export
Replies: 8
Views: 502

Re: TM1 Security Export

Updated code attached. Element security is possible too now. Cube names follow the conventions, for instance: }CubeSecurity (exists) }ClientAccess_Cubes (new): by cube, by client }ClientGroupAccess_Cubes (new): by cube, by group, by client }ElementSecurity_Customer (exists) }ClientAccess_Elements (...
by vvsreddy
Wed Nov 04, 2020 10:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security Export
Replies: 8
Views: 502

Re: TM1 Security Export

Hello, There is no built-in way to export this information. Basically, you need to loop over the clients. Then, for each client, get the groups of that user. Lastly, there will a nested loop over elements of the dimension: for each element you will read out the security for the groups of the user. ...
by vvsreddy
Wed Nov 04, 2020 10:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security Export
Replies: 8
Views: 502

TM1 Security Export

Hi, I am kind of new to TM1 and trying to learn TI process. Have a peculiar requirement where i need to export Element Security by users rather than groups. }ClientGroups has security defined as Users per Group & }ElementSecurity_Dimension has the element level security by groups. Any help in export...