Create a Filter Variable
Add a filter variable to your analytic model.
Context
Procedure
- 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.
- 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.
- 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.
-