Using Variables in Views and Reports

Variables can be assigned to Views and Reports, which will be used during the execution by the Calculation and will make them more dynamic. For example, assume you create a map, formula, and scope that use a variable called @CrBudget@. Then, you create a Calculation that uses these artifacts (the map, formula, scope) and the variable called @CrBudget@. When you save data from a View or Report where the @CrBudget@ variable is used, the application passes the selected scenario for execution to the Calculation.
When Variables are used in Views and Reports, for example @CurScenario@, the current scenario is passed to the Calculation. For example, assume you want to save data for several scenarios. Use a variable and pass the variable automatically from a View or Report without accessing the Calculation and manually changing it.

See Also: Defining Substitution Variables

How to Assign Variables to Views?

1. In SpotlightXL, navigate to the Analyze >Design View page.
2. Select the Properties action. The Variable Name and Dimension fields are displayed.
3. Enter variable name and select the associated dimension that is defined in the map, formula, and scope. 
4. Click Save.

Prerequisite

You must have the variable defined in your formula (accessed by navigating to the Model Formula page). You must use the same variable in your Calculation.

On the Model > Calculation page, there are variables defined for the Formula and Aggregation steps.