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

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

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

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