3641861 - How to convert a report based on a (UNV) Universe, to a (UNX) Universe in Crystal Reports?

• How to convert a report from connecting to a Universe (UNV) to connecting to a (UNX) Universe in Crystal Reports?
• The semantic layer, Universe (UNV) is deprecated from SAP BusinessObjects BI 2025, how to convert a report based on a Universe (.UNV), to connect to a (.UNX) Universe in Crystal Reports?

• SAP Crystal Reports 2020
• SAP Crystal Reports 2025

• From Support Pack 04 of Crystal Reports 2020, it is possible to connect to a (UNX) Universe, therefore to convert a report from connecting to a (UNV) Universe to a (.UNX) Universe, use Crystal Reports 2020 with Support Pack 04, or higher.
      
• IMPORTANT NOTE:
  It is not possible to perform the following steps from Crystal Reports 2025 and above, because the (UNV) Universe has been removed from SAP BusinessObjects BI 2025. It is only possible to perform all the following steps in Crystal Reports 2020 with Support Pack 04 or above.
     

1. In the Information Design Tool (IDT), convert the (UNV) Universe to a (UNX) Universe
     
   1.1  In the Information Design Tool, under the menu "File", select "Convert .unv Universe... - From a Repository..."
   1.2  Login to the SAP BusinessObjects BI platform
   1.3  In "Convert .unv Universe", double click on the .UNV Universe to convert, and click "OK"
   1.4  In the next screen, click on "Convert"
   1.5  Once the conversion is completed, click "Close"
       
2. In Crystal Reports 2020 with Support Pack 04 or above, take note of the query used by the report based on the (UNV) Universe
   
   2.1  In Crystal Reports 2020 with Support Pack 04 or above, open the report based on the (UNV) Universe.
   2.2  Under the menu "Database", select "Query Panel" 
   2.3  In "Business Objects Query Panel", take notes, or a screenshot of the Result Objects and Query Filters.
   
                 This information is needed because the query will need to be recreated when converting the reports
                 from a (UNV) Universe to a (UNX) Universe.
   
   2.4 Click "OK"
     
3. In Crystal Reports 2020 with Support Pack 04, perform a Set Datasource Location to the (UNX) Universe
   
   3.1  In Crystal Reports, under the menu "Database", select "Set Datasource Location"
   3.2  In "Set Datasource Location", under "Replace with", double click on "Create New Connection"
   3.3  In the list of available data sources, expand "Universes (unx)", and under it, double click on "Make New Connection"
   3.4  In "BusinessObjects Enterprise Explorer", select the (UNX) Universe   ( The Universe that was converted from UNV to UNX )
   3.5  Click "Open"
   3.6  In the "Query Panel", add in Result Objects, and the Query Filters, the same Dimensions, Measures, and Filters the report used before.
   
            IMPORTANT NOTE: If not all the same Dimensions, Measures and Filters are added, then the database fields missing will be
            removed from the report. If not all the same Filter(s) is added, then the report will return a different data set,  therefore
            it is really important that all the same Dimensions, Measures and Filters are added to the Query Panel. 
   
    3.7  Click "OK"
    3.8  Back to "Set Datasource Location", under "Current Data Source", select the Universe query ( Blue square ) 
    3.9  In the section "Replace with", select the (UNX) Universe query, then click on the button "Update"
    3.10 It may show the Mapping screen when not all the Dimensions, Measures and Filters matched.
            In which case each fields needs to be mapped manually. Once completed, click "Close"
   3.11 Click "Close"
      
4. Save the updated report under a different name, if you want to keep a copy of the original report.

CR, UNV, UNX , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2020 ; SAP Crystal Reports 2025