Create a Restricted Measure Variable
Add a restricted measure variable to your analytic model.
Context
A restricted measure variable is used in the filter condition of a restricted measure (e.g. “Revenue of selected country” with country = <user input>). It can be applied only in restricted measures, and they do not filter the entire data.
Procedure
- You are in the editor of your analytic model. You can create a new restricted measure variable by clicking the background of the canvas and choosing Add Variable in the properties panel. Choose Restricted Measure 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.
To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores. - 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.
-