SAP Knowledge Base Article - Public

3007757 - Caught exception: exception 52731: Hierarchy cache error for hierarchy name occurs when adding a filter for hierarchy object in a story in SAP Analytics Cloud (SAC)

Symptom

The following error occurs when adding filter for hierarchy object 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"

Environment

  • SAP Analytics Cloud 2020.21.15 (SAC)
  • Live HANA

Reproducing the Issue

  1. Create story based on live HANA model.
  2. Add filter for hierarchy object, error happens.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

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 , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0