[go: up one dir, main page]
Scribd
Upload
23 views3 pages

E. Creating Formula Variables

Formula variables serve as placeholders for dynamic values in formulas, allowing for flexible threshold values in exceptions and conditions. They can be manually entered or retrieved via replacement paths. Hierarchy variables and hierarchy node variables provide users with the ability to choose hierarchies and dynamically restrict characteristics in queries.

Uploaded by

hotels.com.gore181
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views3 pages

E. Creating Formula Variables

Formula variables serve as placeholders for dynamic values in formulas, allowing for flexible threshold values in exceptions and conditions. They can be manually entered or retrieved via replacement paths. Hierarchy variables and hierarchy node variables provide users with the ability to choose hierarchies and dynamically restrict characteristics in queries.

Uploaded by

hotels.com.gore181
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

E.

Creating Formula Variables

XIV. Formula Variable


Formula variables are used as a placeholder to provide a dynamic value in a formula, such as a
percentage that changes each month. You can use formula variables in formulas and in calculated key
figures.
In exceptions and conditions, you can use formula variables as flexible threshold values.

13. Example Use Cases for Formula Variables


• Operands in formulas and in calculated key figures that are entered manually when the query is
executed.
• Operands in formulas and in calculated key figures that are retrieved via replacement path, for
example, from an attribute or from another variable.
• Threshold values in exceptions.
• Threshold values in conditions.

Figure 7: Example of the formula variable references the ProductID characteristic

In this example, the formula variable references the ProductID characteristic and is processed by
replacement path reading the gross weight from the ProductID attribute 0GROSS_WT.

XV. Formula Variables


In this video, you learn how formulas can be improved by using formula variables.

11
F. Creating Hierarchy Variables and
Hierarchy Node Variables

XVI. Hierarchy Variables and Hierarchy Node


Variables
There are two types of variable that relate hierarchies: hierarchy variables and hierarchy node
variables.
Often, there are multiple hierarchies that could be used in a query. Hierarchy variables are used to
provide a way for a user to choose a hierarchy when they execute a query. This is an more flexible
alternative than fixing the hierarchy in the query.
Hierarchy node variables represent nodes within a hierarchy. As an alternative to fixing hierarchy
nodes in the query, use hierarchy node variables to dynamically restrict a characteristic. With a
hierarchy node variable, you can apply filters by hierarchy node in a query result.
There are two possible combinations of hierarchies and nodes:
• Hierarchy Node Variable with a Fixed Hierarchy
• Hierarchy Node Variable with a Hierarchy Variable

Figure 8: Hierarchy Node Variable U00_VAR_NODE_001 with the Fixed Hierarchy


P_PRID_HIER_01

12
Figure 9: Hierarchy Node Variable U00_VAR_NODE_001 with the Hierarchy Variable
U00_VAR_HIER_01

XVII. Hierarchy Variables and Hierarchy Node


Variables
In the following video, you explore a scenario with Hierarchy Variables and Hierarchy Node
Variables.

13

You might also like