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