2758909 - Caught exception: exception 52731: Hierarchy cache error for hierarchy name occurs when adding a hierarchy into a table or chart in a story in SAP Analytics Cloud

• The following error occurs when adding a hierarchy into a table or chart in a story in SAP Analytics Cloud (SAC):
  "Caught exception: exception 52731: Hierarchy cache error for hierarchy name: Hierarchy create error for "_SYS_BIC".SQL: column store error:search table error: [34023] Instantiation of calculation model failed; exception 306106: Undefined variable: \$\$xxxxxx\$\$. Variable is marked as required but not set in the query"
• The hierarchy comes from a calculation view based on a HANA live connection.

• SAP Analytics Cloud

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , HAN-AS-INA-SVC , deprecated - please use HAN-DB-ENG-MDS instead , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem