TM1 Forum

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

Thanks for the replies

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

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

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

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