Special Features with Dynamically Changeable Variables 

Use

The Changeable with Query Navigation function allows you to override the variables entry by selecting the dynamic filter.

When using a dynamically changeable variable, that is, a variable with the activated function Changeable with Query Navigation in a query in connection with a free characteristic, you can override the variable entry with the dynamic filter. In other words, you can also access values that are not found in the value area of the variable entry. The values entered for the variables are only used to parameterize the dynamic filter for the start list.

This function is only available for characteristic value variables in the free characteristics. When using such a variable in the filter, it behaves like a “normal” variable that cannot be changed.

When refreshing a workbook in the BEx Analyzer that contains a changeable variable, this variable does not appear in the variable screen, since the values have already been set in the dynamic filter and also displayed. 

For this reason, the value of such variables are also no longer displayed in the text elements for the variable values.

Constraints

When using a dynamically changeable variable for a compounded characteristic, the variable values cannot be dynamically changed when executing the query and the variable behaves like a fixed variable. It some cases, it is not technically possible to make the variable technically changeable. The system then treats the variable like a fixed variable.

In such cases, a system message appears, which explains to you that the variable is set to not changeable.

The following cases lead to the variable being set to not changeable:

·        The superior characteristic is restricted by a dynamically changeable variable. The subordinate characteristic is either set using a fixed variable or a fixed value.

Example: The cost center is compounded to the controlling area. The cost center is set using a fixed variable or fixed value. The controlling area is restricted by a dynamically changeable variable. This variable is converted into a fixed variable.

·        Both the superordinate and the subordinate characteristic is restricted with a dynamically changeable variable.  In this case, the variable for the superordinate characteristic is converted.

Example: For dynamically changeable variables for the cost center and controlling area, the variable for controlling area is set to non-changeable.

·        Both characteristics have been given a dynamically changeable variable. In addition, the subordinate characteristic is restricted to a fixed value. In this case, both variables are set to non-changeable.

Example: The cost center is set to 1001001 and given a dynamically changeable variable. At the same time, the controlling area is also given a dynamically changeable variable. Both variables are treated as non-changeable variables.

·        You are using a dynamically changeable hierarchy node variable and choose not to set the presentation hierarchy uniquely. The node variable is also treated as a non-changeable variable in this case.  

Note: When refreshing variables that have been set as fixed, the system may display no data.

Activities

Note the following when using the Changeable with Query Navigation function:

·        A variable can only be changed in the query definition when it is only used in a drilldown characteristic and when there are no other restrictions to this characteristic aside from these variables.

·        No additional characteristic is allowed to be compounded with a variable to the affected characteristic.

·        For hierarchy node variables, the hierarchy must match the presentation hierarchy that has been set up.

·        The characteristic value is not allowed to be moved, for example offset –1. In addition, the variable is no longer changeable with the query navigation.