Migrating Crystal and Webi Reports with Universe from 1 folder to different folders

[frikkie_nagel]

Hi There

Does anybody know of a way to do the following

this is for BOE XI 3.1 SP 6 FP 6.2 on Windows 2008 R2

We have multiple Crystal and Webi reports developed from 1 universe and we need to copy these Crystal and Webi  reports to different folders in the same CMS  for example

Universe Dev > Universe Folder Dev -  Crystal and Webi Reports set in Dev Folder

Create a copy of the Dev Universe to Universe Folder Test – Copy the Dev Crystal and Webi Reports to Folder Test we need to Map it to the universe in the Test Universe folder(Copy of the Dev Universe)

Create a copy of the Dev Universe to Universe Folder UAT– Copy the Dev Crystal and Webi Reports to Folder UAT we need to Map it to the universe in the UAT Universe folder(Copy of the Dev Universe)

Create a copy of the Dev Universe to Universe Folder PROD – Copy the Dev Crystal and Webi Reports to Folder PROD we need to Map it to the universe in the PROD Universe folder(Copy of the Dev Universe)

The reason for this is each of these universe are connected to a different database i.e Test, UAT, Prod and we have over 200 reports and at the moment we have to manually map each report to the new universe individual which take up hours.

I have tried Lifecycle manager but came to the conclusion it cannot achive this

1. You cannot change the universe attached to the Crystal and Webi reports
2. you cannot promote Reports and Universes in the Same CMS to different folders
3. you cannot change the folder even if you promote jobs between servers

Does anybody know of a way to do this

[Former Member]

Hi,

The way you should do this is to have 4 different BO systems, Dev, Test, UAT and Prod.

Having this will allow you to use the same universe across all systems, but the connection to the database will be different on each system.

Not only will this allow you to smoothly report off different data sources, but you will also be able to upgrade and make configuration changes without impacting your production system.

Cheers,

Josh

[frikkie_nagel]

Hi Josh,

Yeah, I know this will work on 4 different systems but I require this to be on 1 BOE Environment(server)

[Former Member]

well then you're out of luck cause you are trying to do something that wasn't meant to be done.

I guess you can try to create some custom manual process, but that won't be an easy task. If you don't want to use multiple environments then I'm afraid you're stuck with changing the connections manually, which is very time consuming and very error prone.

Good luck

Cheers,

Josh