SAP Knowledge Base Article - Preview

2578978 - Variable is marked as required but not set in the query for hierarchy view in AO


Open the hierarchy based Calculation view with mandatory Input Parameters defined on the view in Analysis for Office. The error shows up as:

Caught exception : exception 42111: SQL Error : sql processing error: Hierarchy create error for \"_SYS_BIC\".\"<Calculation_View>\" error: SQL: column store error: search table error:

[34023] Instantiation of calculation model failed;exception 306106: Undefined variable: \\$\\$<Variable_Name>\\$\\$. Variable is marked as required but not set in the query\u000a\u000a",



  • Analysis for Office 2.x
  • SAP HANA Database SP 12 Revision 122.x


SAP HANA 1.0, platform edition


IP, fail, SAP HANA, Undefined, variable, 42208 , KBA , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , BI-RA-AO-XLA , Excel Addin , Problem

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.