SAP Knowledge Base Article - Public

3629940 - 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 

Reproducing the Issue

  1. Login to SAC;
  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 for applying variable;
  7. Create a table/chart;
  8. Notice the variable you set in the model does not filter the data.

 

Cause

This is behavior by design.

Resolution

  • Variables are intended for use within formulas and calculations rather than for filtering purposes. The "Defining Variables" section is part of the "Formulas and Calculations" chapter in the Help Guide.
  • In the Modeler, variables act as placeholders that are assigned default values. Within stories, users can then select or adjust these variable values, enabling formulas to dynamically operate with different numeric inputs or datasets

See Also

Keywords

variable, story, model, enter, chart, table, set, formula, filter, data , KBA , LOD-ANA-ML , SAC Modelling , Bug Filed

Product

SAP Analytics Cloud 1.0