Can I Copy Security Groups Between Test & Prod?

[GregK]

We are working on deploying our initial TM1 applications to our production environment. We have hundreds of groups we build manually in our test instance. Is there a way to copy these groups for our test instance to our production instance? Not looking forward to manually recreating all these groups in production.

We are on version 10.2.

[Alan Kirk]

We are working on deploying our initial TM1 applications to our production environment. We have hundreds of groups we build manually in our test instance. Is there a way to copy these groups for our test instance to our production instance? Not looking forward to manually recreating all these groups in production.

We are on version 10.2.

First suggestion; reconsider your security model. Hundreds of groups should rarely be necessary.

Second suggestion; probably the easiest way is to just export the }Groups dimension to a text file, then use the text file to create them in the Production environment. There are two basic ways of doing this.

With the manual way you just right click on the dimension and export it. You then open it up in Excel, and save it as an Excel file with the name "}Groups.xdi" (You need to surround it in quotes to do this, otherwise it'll become Groups.xdi.xlsx.) Then you can save the .xdi on your new server using the "Dimension Save" command in the Developer group of the TM1 ribbon.

The other way is to use TI to export the dimension to a text file, then have a new TI on the production server read that file in. Use the AddGroup TI function to create the groups.

Whatever method you adopt, make sure that you understand the purpose of the GroupsCreationLimit parameter in the config file of the server, and be aware of what it's set to in your case. (Note also the caution in the article that I've linked to there, and how it connects to suggestion 1.)