SAP Knowledge Base Article - Public

2884953 - Exception 306106: Undefined Variable when using Live Hana connection for Geo Mapping in SAP Analytics Cloud (SAC)

Symptom

When using a live Hana connection with an input parameter for Geo Mapping, you get the following error when trying to refresh the story:

Caught exception: exception 42111: SQL Error : search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: \$\$<Variable Name>\$\$. Variable is marked as required but not set in the query exception 42111: SQL Error : search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: \$\$<Variable Name>\$\$. Variable is marked as required but not set in the query

Environment

  • SAP Analytics Cloud (Enterprise) 2019.19
  • Hana 2 SPS 03

Reproducing the Issue

  1. Create a story off of a Hana calculation view which has an input parameter
  2. Add a Geo Map
  3. Refresh the story

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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0