Creating a Query (Enhanced)
The function Constant Selection has been enhanced. Several examples have been added to the documentation.
This section describes functions, enhancements and changes that apply as of BW back end version 7.4 SPS13 / 7.5 SPS00.
The Constant Selection property is available for selections in structural components, cells and restricted key figures in queries.
If you go to the General tab and then go to the Constant Selection screen area and select total as constant, this means that this selection cannot be used at runtime for navigation and filtering. Therefore this selection can serve as a reference size.
You can also define components of selections - individual characteristics and their filter values - as constant. To do this, open the Edit Selection dialog box, go to the Edit Selection screen and choose Constant Selection from the context menu of the selection component. During navigation, the selection only remains unaffected by filters with relation to this characteristic.
On the Calculations tab, you can configure local calculation settings for a formula or a selection. Several examples have been added to the documentation.