Introduction
Standard Variables can be referenced in a number of different locations, including SQL Rules, MDX Rules, Forms, Dashboards, and more. To reference a Standard Variable, use the format: ${variable_name}
Note: For more information on defining Standard Variables, refer to this article.
SQL Rules
All Standard Variables are contained in the [dbo].[ApplicationVariables] table. You can use the VariableName in your SQL Rules.
MDX Rules
Standard Variables can also be used in MDX scripts. Upon deployment, the variable values will be deployed in place of the variable names.
Forms
We can also use Standard Variables when designing Forms. In the example below, ${Aggregate Scenario}, ${Prior Scenario}, ${Prior Months}, and ${Forward Months} are all Standard Variables.
To add a variable, choose the axis dimension (i.e., row or column) where you want to add the variable, then click Variable in the ribbon.
Dashboards
Standard Variables can be used in Dashboard Text and Image Components as well.
Note: For more information on using variables within a Dashboard, refer to the System Variables in this article.
In the example below, the variable ${Current Year} was configured with the value 2019. The value will display when you click off the component.
In addition, Standard Variables can also be used with hyperlinks, both through text and images. You might use this feature to direct traffic between developer and production environments.
