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:

  • long runtime of an MDX statement
  • 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 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, 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 , KBA , mdx , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW-BEX-OT , OLAP Technology , How To

About this page

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

Search for additional results

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