SAP Knowledge Base Article - Preview

2462021 - Error occurred while executing a MDX statement. The error message is: A hierarchy is missing in an operand expression: [Member: [A].[Hier].[All].[(all)]]

Symptom

The following error occurs when processing a BPC dimension with dimension member formulas and HANA MDX enabled:

"Error occurred while executing a MDX statement. The error message is: A hierarchy is missing in an operand expression: [Member: [A].[Hier].[All].[(all)]]"


Read more...

Environment

  • SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver
  • SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver
  • SAP HANA 1.0 database:
    • Revisions >= 122.07 (SPS12)
  • SAP HANA 2.0 database:
    • Revisions >= 002.00 (SPS00)

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 7.5, version for SAP NetWeaver ; SAP NetWeaver 7.4

Keywords

EPM, BPC NW, Business Planning and Consolidation for NetWeaver, HANA MDX, BPC NW, Embedded, standard, classic, unified, BOPC, PARENTH1, Error occurred while executing a MDX statement , KBA , incorrect syntax error , invalid result set , EPM-BPC-NW , NetWeaver Version , BW-PLA-BPC , BPC 'embedded model' , 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.