Symptom
- Cannot connect to the Universe semantic layer, when it is based on SAP BW.
- Able to connect to the same Universe based on the SAP BW BEx Query in Web Intelligence.
- Trying to connect to a Universe built against an SAP BW Cube or BEx Query fails in Crystal Reports.
Environment
- SPA Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In the Universe Design Tool, create a Universe based on an SAP BW Cube, or BEx Query.
- Publish the Universe to the repository.
- In Crystal Reports, unable to connect to the Universe based on the SAP BW Cube or BEx Query.
Cause
- Crystal Reports is not designed to connect to OLAP Universes.
Resolution
- Use the SAP BW MDX Query Driver, to connect to SAP BW Cubes, or SAP BW BEx Queries in Crystal Reports.
Keywords
CR, BExQuery, UNV , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020