Background about the Business Objects Universe Conversion project

As part of SAP's evolution of the Business Objects platform, they will no longer support the legacy universe format in the next major update. SAP introduced a new universe format in 2015, and AITS has been creating all new universes in that format since then. However, many of our universes were created prior to 2015 and remain in the legacy format. These older universes need to be converted to the new format at this time.

Once the legacy universes are converted to the new format, all documents that query those universes will need to be repointed from the legacy universe to the new universe.

All documents stored correctly in the EDDIE repository will be automatically repointed to the new universe. If you as a user and your unit store all needed documents within the EDDIE repository, there is nothing you or your unit will need to do for this part of this project, other than making sure the documents are stored correctly.

However, if you or your unit use the Web Intelligence Rich Client application on your desktop and store reports outside the EDDIE repository (on a user’s desktop, on a unit’s network drive, in a Box folder, etc.), these documents will not be automatically repointed. They must be manually repointed by the user within 90 days of the conversion.

Universes will be converted in groups based on subject area. AITS will be sending communications to users with access to the affected universes throughout this project. You will know when universes are to be converted, and when the 90-day time frame ends.

How to Manually Repoint Documents that use Custom Query Scripts

1. Launch the Web Intelligence Rich Client application, or log into EDDIE, and open the document that needs to be repointed.
2. Ensure you are in Design mode (Alt + 2).
3. In the Toolbar along the top, in the Query section, select the Edit icon.

Note: the 'Use custom query script' radio will be checked if Custom SQL is being used in this query. 

1. At the top, select the Show Query Script icon to view the custom SQL being used.
2. Copy the custom SQL being used and Paste/Save it in Notepad for future use using the ReportName_QueryName_Date.sql naming convention.
3. Select Close and then select Cancel to get back to the report builder section.
4. In the Toolbar along the top, in the Query section, select the ellipse icon and choose Change Source.
5. Select the Data Provider corresponding to the Data Source that needs to be repointed and select OK.
6. Select the radio button next to Specify a new data source, and then select the Select a Data Source button.
7. Select Universe and select OK.
8. Scroll or search for the name of the new universe, select it and select OK.
9. Select Next.
10. Leave the Selected strategy order in the default order (Same ID > Same technical name > Same path > Closest name > Same name), and select Next.
11. Since the conversions in this project are simply to change the format of the universe itself, and the objects are exactly matched between the old and new universes, there should be no ambiguous mappings or anything to fix manually.
12. Select Finish.

Note: you should receive a message saying the change was successful at this point.

1. In the Toolbar along the top, in the Query section, select the Edit icon.
2. At the top, select the Show Query Script icon.
3. Select the Use custom query script  radio button and Paste the SQL script you copied to notepad previously.
4. Select Validate to make sure the query is error free, and then select Save to save the query.
5. Select Run to run the query using the custom SQL script.
6. Save the document and the changes you just made.