SAP Knowledge Base Article - Preview

1721908 - Error BRAINOLAPAPI 510 When Executing MDX Statement

Symptom

  • 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.


Read more...

Environment

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

Product

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

Keywords

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.