2632620 - BRAINOLAPAPI 012: Unknown error when executing MDX

Running e.g a Webi or Power BI Report (or some other frontend using the BW MDX interface), one or all of these error messages are returned:

• BRAINOLAPAPI: 012 Unknown error when executing MDX

Not always all messages are handed over from the parser and different root causes can be observed.

Issue 1:

• BRAIN 890: CL_RSDM_READ_MASTER_DATA->_SIDVAL_DIRECT_READ2
• BRAIN 299 CL_RSR_MDX_BXML_FLATTENING GET_LEADING_COLUMNS_DATA-01-
• RS_EXCEPTION 301 CL_RSR_MDX_BXML_FLATTENING GET_LEADING_COLUMNS_DATA

Issue 2:

• BRAIN 299: System error in program CL_RSR_HIERARCHY and form _MEM_UNAMS_TO_MEMBERS-01-
• BRAINOLAPAPI 510: Value <VALUE> for characteristic <IOBJ> unknown

Issue 3:

• Previously working MDX statement are highlighted with BRAINOLAPAPI 012 after an BW upgrade or patch.
• A dimension is only allowed on one axis as described in SAP Note 2398275.

Issue 4:

• "Unknown error when executing MDX"
• "Syntax error in MDX statement"
• "Termination: Error when executing query"

Issue 5:

• The user that is running the MDX-Statement is missing authorization for the BW query. This can be checked in transaction MDXTEST. See SAP Note 1412800.

Read more...

• SAP Netweaver
• SAP BW/4HANA

SAP BW/4HANA all versions ; 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

WIS 10901, BRAINOLAPAPI 012, BRAINOLAPAPI012, Unknown error, _SIDVAL_DIRECT_READ2, BRAIN890, CL_RSR_HIERARCHY, _MEM_UNAMS_TO_MEMBERS-01-, BRAINOLAPAPI 510, umlaut , KBA , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW4-AE-API-MDX , Multidimensional Expressions , Problem