Deploy TARGIT analysis and user dimensions to a similar database
Hi,
We often have the case that we have two similar databases: Development and Release environment. The development databases and included cubes are only visible to some key user. But often they build some analysis for testing purposes. After deploying to the release database, users are not able to change the database connection inside the TARGIT client. There is only one way: Open the vxiew files in file explorer of the TARGIT server and search/replace the text "Development" to "Release". That is not very comfortable.
However, this problem is not only to vxiew-Analysis files, but also to user dimensions, which should be used by multiple databases. It is not possible to redirect them to another database. That is really sad because users have to recreate them.
Comments
I agree. We have the same issue.
I remember TARGIT developed a "tool" to deploy TARGIT Documents from one system (e.g. "Test") to another system (e.g. "Prod")
Hello, where can I find this tool?
Hello Georg and everyone else,
It is correct that, for a few versions, we had a migration tool. However, due to major changes in the architecture, this tool soon became obsolete.
We acknowledge the need for such a tool and we are currently looking into how we can provide this service again.
For now, please have a look at the migration documentation: https://community.targit.com/hc/en-us/articles/15382145573660-Migration-to-a-new-server
BR / Ole
Hi Ole, how can I copy the User Dimension to the new server? I have try this but the analysis was not possible to use on the new server. Nice regards Georg
Hi Georg,
The safe way is to copy everything - as described in the above linked migration article. The downside of this is of course that everything potentially already existing on the new server will then be overwritten.
If you have a single User Dimension on the old server - that you would like to port to the new server, *without* overwriting any of the other existing user dimensions on the new server, then you should look into the C:\ProgramData\TARGIT\ANTServer\Settings\UserDimensions folder on the old server.
The Index.xml contains an overview of all the user dimensions currently in use on your old server. Search for the name of the desired user dimension and note the ID of that user dimension. Now, you can find the user dimension file with a name identical to the ID, also in the C:\ProgramData\TARGIT\ANTServer\Settings\UserDimensions folder.
Copy this file, e.g. AD49DF0A-88E0-4319-AFAB-42DBAA28227C.xml, to the UserDimensions folder on the new server. Also, modify the Index.xml on the server to contain an entry for this user dimension. You can copy this from the old Index.xml file - everything between <shareduserdimension id="{AD49DF0A-88E0-4319-AFAB-42DBAA28227C}"> to </shareduserdimension> for that single user dimension.
Important: Make a backup copy of the C:\ProgramData\TARGIT\ANTServer\Settings\UserDimensions folder on the new server before making any changes. If something fails, if you somehow invalidates the Index.xml file, your TARGIT solution may crash and will not be able to restart.
BR / Ole
Please sign in to leave a comment.