SAP Knowledge Base Article - Preview

2060530 - BEx Query not returning data in Crystal Reports for dimension that have no data

Symptom

  • Missing data.
  • Dimension that have no data, are not displayed in Crystal Reports.
  • Viewing an SAP BW BEx Query in BEx Analyzer returns data for all the dimension regardless there is posted data or not for it in the SAP BW Cube, when the BEx Query dimension is formatted to display "Master Data".
  • When the BEx Query option "Access Type for Result Values" is set to display "Master Data" for a specific Characteristic, it displays all the Master Data values for the Characteristic in BEx Analyzer, but it is missing the one that have no values when reporting off the same BEx Query in Crystal Reports.


Read more...

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
               
  • SAP BW 7.1
  • SAP BW 7.2
  • SAP BW 7.3
  • SAP BW 7.4

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

CR, BEx, query, missing data , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.