Solution : https://service.sap.com/sap/support/notes/820925 (SAP Service marketplace login required)
Summary :
This SAP Note outlines limitations and unsupported features within the SAP Business Warehouse (BW) MDX engine. Key restrictions include a maximum cell count of one million for SAP BW MDX queries and specific unsupported operators such as %RT, %GT, %CT, and %XT among others, primarily due to their reliance on Special List Geometry exclusive to BEX Analyzer. Additionally, direct specification of levels beyond 20 and usage of more than 10 hierarchies in a drilldown are not supported, potentially resulting in errors. Other notable constraints involve handling variables, hierarchical properties, and attribute adjustments during MDX execution, alongside mention of restrictions applicable to OLEDB for OLAP's own query constructs. Also discussed are implications of using MDX keywords as BW characteristic values which could lead to syntax errors. Usage of the binary XML-based Flattening API with certain dimensional settings is likewise clarified.
Key words :
form checks_for_odbo type-pool rzi0, binary xml-based flattening api, binary xml flattening api, support time dependent hierarchies, consequence time dependent hierarchies, prerequisites general information, special list geometry, suppress empty records, calculated key figures, calculated single values
Related Notes :
| 1381821 | Memory and Performance Analysis for MDX |
| 1272044 | Analyzing MDX problems |
| 845955 | MDX: No parallel execution of several MDX commands |
| 838800 | Composite SAP Note for consulting notes about MDX/OLAP BAPIs |
| 646699 | Restrictions during the use of BW queries |
| 323779 | OLE DB for OLAP features and restrictions |