SAP Knowledge Base Article - Public

2947253 - Got error "Query can't be executed without setting values for all mandatory variables" When trying to open a dashboard from embedded SAC

Symptom

Got error "Query can't be executed without setting values for all mandatory variables" When trying to open a dashboard from embedded SAC

Environment

  • SAP S/4HANA CLOUD 2005 / 780

  • SAPUI5 1.75.7

  • Embedded SAC

Reproducing the Issue

  1. Logon to S4HANA.
  2. Open "Manage KPIs and Reports". 
  3. Open a Story. 
  4. Notice the error message:
    "Query can't be executed without setting values for all mandatory variables".

Cause

The error message is a normal behavior in S/4HANA 2005 and earlier release.
Due to SAC product limitation, some default variable values must be saved along with the story, and those values are not exists from your S/4HANA system.

Resolution

To solve the issue, simply fill the table prompt beside the error icon with proper variable values.

You can also refer to online help:
https://help.sap.com/viewer/90c07e91c7a64f328be3fd6b48955b13/2005.500/en-US/8c1d94d30ac84876bfa2b618d3a63b70.html

In 2008 and further release, this error is supposed to be avoided.

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, SAPCloudAnalytic,variable, s4hana, embedded sac, default, mandatory. , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem

Product

SAP Analytics Cloud 1.0 ; SAP S/4HANA Cloud 2005