SAP Knowledge Base Article - Public

3132584 - exception 70006970: Evaluator: type error in expression in SAP Analytics Cloud (SAC) after modifying Hana Query

Symptom

After modifying a Hana calculation view that is used by SAC, any new model created off of the same Hana view throws the error "exception 70006970: Evaluator: type error in expression"

If you extract the MDS query and run it in Hana Studio, you will see that SAC is still using the original version of the Hana view- not the modified version.  Creating a new model does not resolve the issue as SAC will continue to use the old version of the calculation view

Environment

  • SAP Analytics Cloud (Enterprise) 2021.12.10

Reproducing the Issue

  1. Create a Calculation View in Hana
  2. Create a Live Model in SAC which uses that view
  3. Edit the Calculation view
  4. Delete the Live model and create a new Live Model in SAC
  5. Get the error when you use the new model

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, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0