SAP Knowledge Base Article - Preview

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

Symptom

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",


Read more...

Environment

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

Product

SAP HANA 1.0, platform edition

Keywords

IP, fail, SAP HANA, Undefined, variable, 42208 , KBA , HAN-DB , SAP HANA Database , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.