SAP BO Universe and Report Migration Part 1

Migrate Universe from one database to another

·         First backup the original universe in case if something go wrong

·         Launch Designer, import universe from BOE. Import the universe

·         From file menu select Save As and save under a suitable name

·         From Tools menu select Connections and create a new connection pointing to new database server. Note, if may already have such a connection for another universe and if so we should reuse that

·         Once created we can close the Connections dialog

·         From File menu select Parameters.

·         Change connection to use new database connection

·         Update Description so that we can identify our updated universe, for example, increase version number or add Click OK to save changes

·         Select all tables, right click and select rename table

·         Update owner of tables to new database owner

·         Run an Integrity Check. The integrity check should flag all objects and conditions that fail parsing. It should also pick up that a table has changed.

·         Integrity Check once more and if all is well then we are done.

·         Finally export universe back to repository.

Migrating reports from Existing universe to new universe

If you want to switch the universe against new universe then you to do the following . 

·         Open the report

·         Select the ‘Data Access’ Tab

·         Select the ‘Tools’ sub tab

·         Select ‘Change Source’

·         Select the Query to change

·         And set ‘Specify new data source’

·         Click ‘Select data source’ from the drop down

·         Select ‘Universe’ and select the desired universe from the list.

·         If you have more than one query in your report then you may also want to tick the checkbox for ‘Apply changes in all queries sharing the same data source’

·         Click ‘Next’ and ‘Finish’.

·         The quer will then refresh based on the newly specified data sources.

Reports with Multiple Data Provider (Universe) and Merged Dimension:-

·         If your report has merged dimension then it will disappear (if automatic merging is off) after the migration.

·         If your report has merged dimension then it will disappear and automatically re-created (if automatic merging is on).

·         Variables, breaks, filters… created based on merged dimension will be destroyed.

·         Variables which uses the merged dimension will get changed into some wired character.

Reports with Detail Variables associated dimension using merged Dimension:-

                You will receive any error message saying an error has occurred if you have any detail variable with associated dimension using merged dimension, the report will not migrate

 Workaround:-

                   Edit the detail variable and change the associated dimensions to single data provider variable and do the conversion, after the successful conversion of the report, change the associated dimensions back to merged dimension.

An error has occurred error message:-

                                                  

                                This error message can occur during conversion if you have

·         Detail variables with associated dimension using merged dimension

·         Report condition objects has list of values associated with it

·         Query filter object using result from another query