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.
- SAP Online Help: MDX as Basis for the Interfaces
- Microsoft Reference: Multidimensional Expressions (MDX) - Reference
Restrictions
Find an overview of Bex features ignored or not supported by the MDX interface:
- 820925 MDX - Restrictions
- MDX: 1 million cell limit
- Safety Belt: RSADMIN parameter 'MDX_STOP_AFTER_COMBINATIONS'
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
- BW MDX Parser
- Troubleshooting BW MDX Parser Related Issues
- Instruction to download the RFC library file
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:
- Troubleshooting the MDX interface (linked via KBA 2498274 - HowTo: Troubleshooting the MDX interface - decision tree)
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?
- MDX syntax and concepts (3) - Hierarchies
- MDX syntax and concepts (4) - SAP Variables
- MDX syntax and concepts (5) - Calculations, Members and Sets
- MDX syntax and concepts (6) - Properties
- MDX syntax and concepts (7) - EMPTY, NON EMPTY and No keyfigures
Special topics
- MDX and BW authorizations
- Transaction MDXTEST
- MDX Execution Modes
- MDX MDDataSet and MDProvider BAPIs
- MDX and F4 (LOV or GetMembers)
External (non-SAP) frontends and vendors using the MDX interface
Internal (SAP) frontends and applications using the MDX interface