SAP Knowledge Base Article - Preview

1721908 - Error BRAINOLAPAPI 510 When Executing MDX Statement


  • When executing a MDX statement in transaction MDXTEST, you get error:

Value <hierarchy node value> for characteristic xxx is unknown. (BRAINOLAPAPI 510)

The issue described here has following pre-requisites:

  • The MDX statement retrieves data from a BW query
  • In the BW query, you have defined exclude hierarchy node filter in 'Characteristic Restriction' section in query designer.
  • The MDX statement has hierarchy node selection for this hierarchy. The selection is valid according to the defined filter.

You can get more detailed information in 'Reproducing the Issue' section.



  • BW 7.x
  • BW Query Designer 7.x
  • BW SP level below the list in Note 1730306


SAP Business Warehouse all versions ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; 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


BRAINOLAPAPI 510, BRAINOLAPAPI510, hiearchy node, hard filter, Characteristic Restrictions, Exclude, MDX statement, Multidimensional Expressions, Filter for hierarchies , KBA , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW-BEX-OT-OLAP-HIER , Using Hierarchies , 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.