Are there any best practices/standards on moving reports/universes from one repository to another. We are planning to move our reports/universe from Dev environment to UAT on weekly basis.
Can we do it using repositories dumps (so that it can be scheduled and automated) or do we need to manually export the reports to new repository?
The persons managing the two environments are different. That means the General Supervisor user ids are different in two repositories. However we can create same set of user ids for other users. Could that be an issue?
How do we take care of the “You are not authorized to view this document” message while moving the reports b/w repositories?
Thanks Dave,
Taking i/ps from all posts, it seems the only way to achieve this is to do it all manually.
As I will be migrating docs on weekly basis, so I was looking for some automated process. If the number of reports increases to more than 100 in future, the manual process will cause pain and will take hell lot of time.
If I take a back up of whole of Dev repository and restore it in UAT, will that idea work?
So the UAT structure will be similar to Dev strucuture every week. All the Universe, Doc and user ids will remain same in Dev and UAT in this way.
The “magic ID” values from the security domain will not be the same. And I don’t think you want to do a complete backup of the repository, as your test users and production users are likely different, not to mention the inbox docs, and other stuff, would get out of sync.
It is possible to write code (VBA) to do the migration. I wrote some code for a client (which means that I cannot release it here, unfortunately, as the client paid for the development effort) that was divided into two parts. Part A connected to the source repository, imported documents, repointed the documents to a “non-secured” version of the universe, and then did a save for all users on each document.
Part B then was logged into the seconde repository, opened each doc, repointed each data provider to a “secured” version of the universe in the new repository, assigned categories and exported.
If you need to do this on a weekly basis, I would suggest that you look at the code samples here on BOB. While there isn’t a complete solution, there are enough samples that do various parts of what you need to get you started.
(BOB member since 2002-06-06)
(BOB member since 2002-06-11)