SAP Knowledge Base Article - Public

2803421 - "Filter:In-List query with reference only allowed on aggregating calculation nodes" error occurs when creating story based on some hana view

Symptom

  • Error occurs when creating story based on some hana view
  • Error message:Caught exception: exception 70034011: Inconsistent calculation model; \$message\$=Inconsistent calculation model; calculationNode(N_0006_PROJ) -> Filter:In-List query with reference only allowed on aggregating calculation nodes

Environment

  • SAP Analytics Cloud 2019.7

Reproducing the Issue

  1. Open the story created based on specific hana view.

Resolution

This issue is  fixed in SAP HANA version 1.00.122.24 and higher. Upgrade your HANA software to this version or greater.

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, filter, in list , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BR , Digital Boardroom (DiBo) , LOD-ANA-PL , Planning Functionality, Planning Models , LOD-ANA-PR , Predictive Scenarios, Smart Predict , Problem

Product

SAP Analytics Cloud 1.0