SAP Knowledge Base Article - Public

1302628 - Unable to connect to Universe based on SAP BW Cube or BEx Query in Crystal Reports

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

  1. In the Universe Design Tool, create a Universe based on an SAP BW Cube, or BEx Query.
  2. Publish the Universe to the repository.
  3. 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