1648842 - Error: 'Syntax error in program /CRYSTAL/MDX_READ_DIMMESIONS==CP' when refreshing a report based on a BEx Query in Crystal Reports

• Reports based on BEx Queries generate an error in Crystal Reports.
• Error: 'Syntax error in program/CRYSTAL/MDX_READ_DIMMESIONS==CP'
• When refreshing a report based on an SAP BW BEx Query in Crystal Reports, or in SAP BI LaunchPad, it fails with the error:
      
     "Database Connector Error: 'Syntax error in program /CRYSTAL/MDX_READ_DIMENSIONS==CP . (SYNTAX_ERROR)'"

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
     
• SAP BusinessObjects Business Intelligence platform 4.1
• SAP BusinessObjects Business Intelligence platform 4.2
• SAP BusinessObjects Business Intelligence platform 4.3
       
• SAP BW 7.4
• SAP BW 7.5

1. In Crystal Reports, or in SAP BI LaunchPad, open a report based on an SAP BW BEx Query.
2. Refresh the report.
3. It then fails with the error: 'Syntax error in program /CRYSTAL/MDX_READ_DIMENSIONS==CP' 

• To connect to SAP BW BEx Query, Crystal Reports requires functions and programs loaded by the SAP Integration Kit Transports on the SAP BW System.
      
• This error occur when the SAP Integration Kit Transports corresponding to the version of Crystal Reports used have not been imported on the SAP BW System.

• Load the SAP Integration Kit Transports that correspond to the version of Crystal Reports used, to the SAP BW System.
     
• The SAP Integration Kit Transports that are required to load on your SAP System are located in Crystal Reports product installation package and product update.
    
1. Unzip the Crystal Reports installation package or product update corresponding to the version of Crystal Reports you are using.            
         
2. Navigate to the folder: \Collaterals\Add-Ons\SAP\Transports
      
3. Open the file: transports_EN.txt
       
   This file contains the versions of the SAP Integration Kit Transports to load on your SAP System.
   Below is an example of an extract of the content of the file displaying the version of the SAP Integration Kit Transports to load:
   
      * Open SQL Connectivity transport (K900754.R21 and R900754.R21)
      * Info Set Connectivity transport (K900780.r21 and R900780.r21)
      * Row-level Security Definition transport (K900689.r21 and R900689.r21)
      * Cluster Definition transport (K900690.r21 and R900690.r21)
      * Authentication Helpers transport (K900691.r21 and R900691.r21)
      ...
           
4. The Transport files to load on the SAP BW System are located in the following folders: 
        
       \Collaterals\Add-Ons\SAP\Transports\unicode_compatible\cofiles
       \Collaterals\Add-Ons\SAP\Transports\unicode_compatible\data
         
5. Contact your SAP BASIS administrators to request them to load the SAP Integration Kit Transports on the SAP BW System.
     
   Note:
   You do not have to load all the SAP Integration Kit Transports, but only those required for the type of connectivity used. 
   In this case, you need to load the SAP BW MDX Query Transports.
      
   For more information, see the Transports chapter in the following document:
     
         SAP BusinessObjects Integration for SAP Solutions Installation and Administration Guide
    
   The document is available in the Attachments section below, under the name: xi31_sp5_bip_sap_inst_en.pdf   
      
   The document was written for older versions of the product, but the information it contains it still relevant with the latest version of Crystal Reports, and SAP BusinessObjects Business Intelligence platform.

MDX, DIMMESIONS,FWM 00001 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020