SAP Knowledge Base Article - Public

2615389 - Month/Year Variable in the selection criteria is not updated automatically using Live Data connection in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

The Month/Year variable in the filter selection criteria is not updated automatically depending on the Current Month/Year in an SAP Analytics Cloud story despite this variable being defined in the BEx Query.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Open a story using a BW Live Data Connection with the Month/Year variable defined in the BEx Query
  3. Change the Month/Year filter selection to a different date
  4. Save and exit the story
  5. Reopen the Story and notice that the current Month/Year will not be displayed despite refreshing and the last user input will remain.

Resolution

Please make sure you define the flag in the BEx query using the following options:

  • Refresh Variables: Refresh Dynamically

exit.png

The 'Refresh Variables' flag and the technical background are described in more detail in the SAP Community Wiki: Variable Refresh.

See Also

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

Keywords

EPM, 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, 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 , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0