Variable Type
When creating a variable, the variable type indicates for which object you can use a variable.
The following table provides an overview of the variable types:
Type |
Description |
|---|---|
Characteristic Value: Characteristic Value Variable |
Characteristic value variables represent characteristic values and can be used wherever characteristic values can be used. If you restrict characteristics to specific characteristic values, you can also use characteristic value variables instead of fixed values. |
Hierarchy: Hierarchy Variable |
Hierarchy variables represent hierarchies and can be used wherever hierarchies can be selected. If you restrict characteristics on hierarchies or presentation hierarchies, you can use variable hierarchies with hierarchy variables instead of fixed ones. |
Hierarchy Nodes: Hierarchy Node Variable |
Hierarchy node variables represent nodes in a hierarchy and can be used wherever hierarchy nodes can be used. If you restrict characteristics to hierarchy nodes, you can also use hierarchy node variables. |
Text: Text Variable |
Text variables represent a text and can be used in descriptions of queries, calculated key figures and structural components (selections and formulas). If the system finds either no values or multiple values for the reference characteristic when replacing text variables, and is thus unable to determine a unique value, it outputs the technical name of the text variables as the result. |
Formula: Formula Variable |
A formula variable represents numeric values and can be used in formulas and for selecting exceptions and conditions. Example
By using a formula variable for the interest rate, you do not need to process the current interest rate until after you have executed the query. |