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.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP NetWeaver
• SAP BW/4HANA

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