The Use Selection of Structure Elements option influences system performance. This function should therefore normally be activated. This function only reads data for the selected structure elements. This means that the drilldown characteristics can display fewer attributes.
Country | Sales Volume (DE) | Sales Volume (US) |
---|---|---|
DE | 50 | |
US | 60 |
Country | Sales Volume (DE) |
---|---|
DE | 50 |
US |
Country | Sales Volume (DE) |
---|---|
DE | 50 |
Technically speaking, the system only passes to the database the selections and key figures of the columns (or structure elements, to be more precise) that are required to determine the filtered elements. This means that cells that only exist because of non-selected structure elements are not displayed.
Structure elements with constant selection are an exception, as they do not create any objects (see Object Generation). If the selection contains a structure element with constant selection, data for further structure elements outside the selection are requested.
Country |
Sales Volume (Constant Country Selection) |
Sales Volume (DE) |
Sales Volume (US) |
---|---|---|---|
DE |
300 |
50 |
|
US |
300 |
|
60 |
Country |
Sales Volume (Constant Country Selection) |
Sales Volume (DE) |
---|---|---|
DE |
300 |
50 |
US |
300 |
|
If you deactivate this function, the data is read for the entire structure or for both structures from the database. Therefore this function can also not be activated if the query has read mode 'A' (see Read Mode).
You can expect a significant improvement in performance from using this function in the following scenarios:
Deactivating this function does not normally bring any advantages.