SAP Knowledge Base Article - Preview

2498274 - HowTo: Troubleshooting the MDX interface - decision tree

Symptom

The following decision tree will assist you with analysing and troubleshooting MDX issues with BEx queries.

Issues that can be identified/solved/explained/understood with this decision tree are:

  • performance or long runtime of an MDX statement
  • TIME_OUT when running MDX sentence
  • memory dumps when running MDX statement
  • GetMembers or LOV displays different values then F4 in BEx query
  • WebI and other BO issues with BEx query
  • MDX Parser times out
  • analysing MDX issues for non-SAP software vendors like Cognos, Arcplan, Tableau, Microsoft Reporting Services, Qlikview, ...
  • APD and RSCRM issues with the MDX interface
  • ...


Read more...

Environment

SAP Business Warehouse 7.x and higher

BW/4HANA

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

performance, memory, time out, time-out, time_out, runtime, MDX, SQL, TIME_OUT, slow, long, DBTRANS, DBSEL, TSV_NEW_PAGE_ALLOC_FAILED, STORAGE_PARAMETERS_WRONG_SET, SYSTEM_NO_ROLL, BRAINOLAPAPI, MDXTEST, MDX parser, incorrect data, wrong data, no data BPC, EPM, APD, RSCRM, Webi, Web Intelligence, Cognos, Arcplan, Tableau, Qlikview, BW OLE DB Provider for OLAP MDX statement, MDX sentence , KBA , mdx , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW-BEX-OT , OLAP Technology , BW4-AE-API-MDX , Multidimensional Expressions , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.