SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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.

Cause

This is a by design behavior.

Resolution

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.

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

Product

SAP Analytics Cloud 1.0