SAP Knowledge Base Article - Public

2886181 - Data is not filtered after setting a variable in the model in SAP Analytics Cloud (SAC)


The following behavior occurs in SAP Analytics Cloud (SAC):

  • Variable does not filter data in the story.
  • Data is not filtered after setting a variable in the model.


SAP Analytics Cloud (Enterprise) 2020.2.3

Reproducing the Issue

  1. Logon to SAC tenant.
  2. Open a model.
  3. Set a variable (e.g. year).
  4. Save the model.
  5. Create a story based on the model.
  6. A pop-up window appears about applying variable.
  7. Create a table.
  8. Notice the variable you set in the model does not filtering the data.


This is a by design behavior.


The purpose of variables is the usage in formulas and not for filtering. "Defining Variables" is a subsection of "Formulas and Calculations" in the Help Guide.

See Also

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


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 , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-DES , Story Design & Visualizations , Bug Filed


SAP Analytics Cloud 1.0