Create a Filter Variable

Add a filter variable to your analytic model.

Context

A filter variable refers to an attribute. When a story is opened, the variable dialog shows a filter for the attribute.

Procedure

  1. You are in the editor of your analytic model. You can create a new filter variable by clicking the background of the canvas and choosing Add Variable in the properties panel. Choose Filter Variable.
  2. Edit the following properties:

    Property

    Description

    Business Name

    Enter a descriptive name to help users identify the object. This name can be changed at any time.

    Technical Name

    Displays the name used in scripts and code, synchronized by default with the Business Name.

  3. Define the properties of your variable:

    Property

    Description

    Dimension

    Choose the dimension for which the variable should be created.

    Variable filled by

    Choose how the variable should be filled:
    • Manual Input

    • Derive Value: Derived variables are hidden in the data preview or in an SAP Analytics Cloud story. See Derived Variables.

    • Dynamic Default: You get a derived value in the parameter dialog list when opening the analytic preview, and in the variable prompt for an SAP Analytics Cloud story. See Dynamic Default.

    Filter Type

    Choose the Filter Type.

    The filter can be
    • a single value: The user should enter a single value to filter on. You can optionally specify a default value.

    • multiple single values: Allows the user to enter more than one value (or range of values) to filter on. You can also define default values with multiple rows.

    • an interval: Allows the user to enter an interval of values to filter on.

    • a range of values: Allows the user to enter a range of values to filter on. You can also define several value ranges.

    Mandatory

    You can select Mandatory, if the user has to enter a value in the prompt in the preview or the story in SAP Analytics Cloud.