Show TOC

Replacement PathLocate this document in the navigation structure

Use

You use the Replacement Path processing type to specify the value that automatically replaces the variable when you execute the query or Web application.

Integration

Processing type Replacement Path can be used with characteristic value variables, text variables and formula variables.

Features

The following options are available:

Replace with Characteristic Value

Text and formula variables with the processing type Replacement Path can be replaced with a corresponding characteristic value. In the Variables Editor, on the General tab page under Reference Characteristic, you specify the characteristic that is to be referenced by the replacement. On the Replacement Path tab page, you can choose whether the variable is replaced with the From or the To Value and with the Key or the Name of the characteristic value. You can also specify the Offset Start and Offset Length for the output.

CURRENT MEMBER Variables

To define filters that relate to the values of a time characteristic in the drilldown of a query during analyses, define a restricted key figure using a CURRENT MEMBER variable. This is a variable with the replacement path CURRENT MEMBER. The CURRENT MEMBER variable can be used in restricted key figures as either the lower limit or the upper limit in combination with an offset. Only one restriction with a CURRENT MEMBER variable is allowed per restricted key figure however.

Replace with Query

Characteristic value variables with the processing type Replacement Path are replaced with the results of a query. In the Variables Editor, on the Replacement Path tab page, you select the query whose result you want to use as the variable. You can now process the data result of the selected query as a variable in a different query.

Replace with Variable

Characteristic value variables, hierarchy variables, text variables, and formula variables with the Replacement Path processing type can take their values from a different variable.

The following prerequisites apply:

Variable

  • The variable must not be input-ready
  • The variable must represent a single value

Source Variable

  • The source variable must not be a hierarchy node variable
  • The source variable must be input-ready
  • The source variable must exist in the query
  • The source variable must represent a single value or range

In the Variables Editor, on the Replacement Path tab page, you specify the source variable from which the value is to be determined. The value is determined either from the key, the external attribute of the key, the description, or the attribute value. You can specify an Offset Start and an Offset Length for the output here.

The variable is replaced in the Variables screen with each data release.

Activities

In the Variables Editor, on the General tab page, you choose the processing type Replacement Path.

More information: Replacement Path

Example

If you specify a variable as a characteristic value, you do not have to specify a text for the characteristic value right away. You can fill the text field dynamically and specifically for the characteristic that you use for the variable when you execute the query instead. To do this, define a text variable with automatic replacement.