Properties and How They Are Derived
BEx Query Designer offers a reference and reusability concept both for the definition of a query object and for all of the object's properties.
As a user, you can define for each property whether to set its value or derive it from another object. In Query Designer, you can use the Use Default Settings checkbox to derive a property from another object in the query object property dialogs. In some cases, the name of the checkbox can be different, for example the function in the selection properties on the Calculations tab page is called Use Precalculated Value.
When selecting decimal places in the properties dialog, for example, this means that you can either set them on the structure element, or derive them from the restricted key figure used in the structure element.
The following example illustrates a derivation chain over multiple levels:
In structure element Net Sales 2, the scaling factor is defined locally, while the target currency is derived from the restricted key figure and its structure element Net Sales 1.
From the level above it, structure element Net Sales 3 derives the scaling factor from Net Sales 2 and the target currency from Net Sales 1.
The following section provides you with an overview of the objects from which properties can be derived.
List of Objects
| Object | Can Derive Properties from Following Objects: |
|---|---|
|
Characteristic in the filter, in the rows, columns or the free characteristics |
Characteristic in InfoProvider Characteristic in reusable filter |
|
Characteristic in reusable filter |
Characteristic in InfoProvider |
|
Restricted key figure: |
Key figure in InfoProvider Restricted key figure: Calculated Key Figure |
|
Calculated Key Figure |
------------- |
|
Selection |
Key figure in InfoProvider Restricted key figure: Calculated Key Figure |
It is possible that not all properties that an object (in the table on the left) wants to derive are offered by the derived object (in the table on the right). For example, InfoObjects (characteristics and key figures) from InfoProviders have fewer properties than objects that are defined in Query Designer, meaning that not all properties can be derived from the InfoObjects.
In Query Designer, this fact is illustrated by the Use Default Value checkbox being greyed out in the query object properties.
If the Use Default Value checkbox is greyed out for a property, this means that the object is the starting point of a possible derivation chain.