Replacement Path: Replacement from Variable 

Use

Characteristic value variables, hierarchy variables, text variables and formula variables with the Replacement Path processing type can get the value from a different variable. The value is either determined from the key, the external attribute of the key, the description, or the attribute value. You can also define an offset start and offset length.

Replacement path: The variable is replaced on the variables screen upon each data release.

Prerequisites

The following prerequisites need to be fulfilled:

Variable

●     The variable must not be input ready

●     The variable must represent a single value

Source Variable

●     The source variable must be a characteristic variable, a hierarchy variable, a text variable, or a formula variable. (The source variable must not be a hierarchy node variable.)

●     The source variable must be input ready

●     The source variable must be available in the query

●     The source variable must represent a single value or an interval

Features

Replacement Rule

Here you define the source variable.

Replace Variable with

Select Variable from.

Variable

Choose the source variable using the input help dialog . For more information on the using the input help dialog, see Restricting Characteristics.

Variable Represents

Choose from where the value of the variable is to be determined.

●     Key

The variable value is replaced with the characteristic key.

●     External Characteristic Value Key

The variable value is replaced with an external value of the characteristic (external/internal conversion).

●     Description

The variable value is replaced with the name of the characteristic.

●     Attribute Value

The variable value is replaced with the value of an attribute. When you choose the Attribute Value, the Attribute dropdown box is displayed. Select the attribute you want. The system displays all attributes for the characteristic upon which the source variable is defined.

Offset Setting

Using the Offset Start and Offset Length, you can establish the start and length of the text output. For more information on the offset setting, see Replacement Path: Replacement from Characteristic Value.

Using Intervals

You have the following selection options:

●     From value

●     To value

●     Difference

If the source value found is an interval, you can use this setting to specify whether the lower interval limit (from value) or the upper interval limit (to value) is used as the replacement value.

For formula variables, you can also choose the interval difference as the replacement value. Using this setting, you can easily calculate the difference of period boundaries. The interval difference is the from value minus the to value, plus 1. For example, the period January to March gives a result of 3 (the to value 3, minus the from value 1, plus 1).

Examples

Text Variable

You are using a text variable with automatic replacement in a formula. The formula operands have different selections for the characteristic concerned. The automatic replacement would not be able to replace the text variable in that case. If you use replacement from variable, the value of the source variable is used for the text variable.

Hierarchy Variable

The data in an InfoProvider is version dependent. A corresponding hierarchy version (with which a hierarchy is to be used) exists for every version. With replacement from variable, the variable for the hierarchy version can be filled with the variables for the version.

If the versions do not correspond directly to one another, you can create a Hierarchy Version attribute in which the corresponding versions are stored.