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