Page tree
Skip to end of metadata
Go to start of metadata

BW MDX Interface/MDX Processor

Features of BW MDX processing, MDX statement logic, MDX tracing and MDX troubleshooting are discussed. In the following its normally necessary that you are already familiar with the content of the online documentation, please see the links below. Since there are also lots of good SAP notes/KBAs to many of the most important features we tried to point to them in the text whenever reasonable. A comprehensive list of them is given below.


Find an overview of Bex features ignored or not supported by the MDX interface:

  • 820925 MDX - Restrictions
  • MDX: 1 million cell limit
    You also have the option to define a safety belt to limit the amount of data to be processed via the MDX Interface as described in the following SAP note:
    2811586 - Long-running MDX processes block the ABAP application server 

MDX Parser Configuration

SAP Collective Notes

  • List of known corrections dealing with incorrect or missing data
    1156101   MDX: Composite SAP note for incorrect data

  • List of known optimizations to improve runtime and descrease memory consumption:
    1142664   MDX: Composite SAP note about performance improvement

Guidelines for Error Analysis

Use the Guided Answers (decision tree) for troubleshooting:

Please follow the instructions of notes:

  • 1272044 - Analyzing MDX problems
  • 1381821 - Memory and Performance Analysis for MDX
  • 1412800 - MDX and BW authorizations
  • 1628813 - Analyzing problems with SAP BW OLE DB Provider in Excel

RSTT trace

SAP Consulting Notes at a glance

  • 1572018 MDX: Execution types in transaction MDXTEST - BW 7.00-7.11
  • 1769369 Consulting note for external hierarchies and authorizations
  • 1576508 MDX: Overview of the MDX-specific RSADMIN parameters
  • 1574725 MDX: Consulting note for external hierarchies
  • 1530858 MDX: Runtimes are long when the member rowset is determined
  • 1526045 MDX: Non-unique hierarchies, link nodes, and structures
  • 1521799 MDX: Structures and non empty
  • 1253646 MDX: Handling link nodes
  • 1166733 MDX: Handling interval limits in the MDX
  • 834196 Time dependency in MDX

Features / Topics

How to read a simple MDX statement for a BW BEx query? 

Special topics

External (non-SAP) frontends and vendors using the MDX interface

Internal (SAP) frontends and applications using the MDX interface

SAP Support Troubleshooting Guideline