Symptom
- 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.
Read more...
Environment
- SAP Analytics Cloud
Product
SAP Analytics Cloud 1.0
Keywords
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
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.