How to Use Variables in SpotlightXL Views and Reports
  • 1 Minute to read
  • Dark
    Light
  • PDF

How to Use Variables in SpotlightXL Views and Reports

  • Dark
    Light
  • PDF

Article summary

Variables assigned within Views and Reports automate processes during calculations, improving efficiency by eliminating the need for manual adjustments based on predefined parameters or conditions.

To assign variables to views:

  1. In SpotlightXL, go to Analyze > Design View.
  2. Click Properties
  3. Enter Variable Name and select the associated dimension.
  4. Click Save.

  5. Enter a new name for the view. The variable will be added.

Notes:
  • Ensure that the variable is defined in your model's formulas or calculations.
  • Use the same variable consistently throughout your calculation process.
  • For the Reports, navigate to Design > Properties to add variables.

Was this article helpful?