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.