Skip to Content
0
Apr 30, 2014 at 11:30 PM

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

17 Views

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