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

• 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.

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
• SAP Crystal Reports 2025
             
• SAP BW 7.5

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