Characteristic value variables, hierarchy variables, text variables, and formula variables with the Replacement Pathprocessing type can be replaced by 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 time: The variable is replaced on the variables screen upon each data release.
The following prerequisites need to be fulfilled:
Target Variable (= the variable that is to be replaced)
Source Variable (= the variable that is to replace the target variable)
Here you define the source variable.
Replace Variable With
Choose the source variable using the input help dialog . For more information on the using the input help dialog, see Restricting Characteristics.
Choose from where the value of the variable is to be determined.
The variable value is replaced with the characteristic key.
The variable value is replaced with an external value of the characteristic (external/internal conversion).
The variable value is replaced with the name of the characteristic.
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.
If the attribute is time-dependent, the system cannot determine the variable value or does not replace the variable with the expected value, since the key date of the query is not properly taken into account if it is variable.
If the attribute and the target characteristic have the same basic characteristic and this is compounded, the target variable must contain the uncompounded value. Proceed as follows:
Using the Offset Startand Offset Length,you can establish the start and length of the text output. For more information on the offset setting, seeReplacement Path: Replacement from Characteristic Value.
You have the following selection options:
If the source variable 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 to value minus the from 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).
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.
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 from the variables for the version.
If the versions do not correspond directly to one another, you can create a Hierarchy Versionattribute in which the corresponding versions are stored.