Constant Selection in Examples

Data Basis

The data basis for the following examples is the section taken from SAP DemoContent for features described by the query 0D_FC_AE_CNSTSEL_Q008:

Note Note

For more information about SAP DemoContent for Features (transaction RSFC), seeSAP DemoContent for Features.

For more information about the property Constant Selection, seeConstant Selection.

End of the note.

Query 0D_FC_AE_CNSTSEL_Q008
Region	Customer		Calendar Year	Billed Quantity	Net Sales
America	FC016	Plaza Mayor	2004	1 UNIT	3,00 EUR
Europe	FC001	Anchor Inn	2003	1 UNIT	2.00 EUR
Europe	FC001	Anchor Inn	2007	1 UNIT	5.00 EUR
Europe	FC002	Banquetes Bennati Ltd	2006	1 UNIT	2.00 EUR
Europe	FC002	Banquetes Bennati Ltd	2007	1 UNIT	3,00 EUR

Example 1: Query with two structures and combination of constant selection on the structure element (CSE) and constant selection on the characteristic (CSC)

Query 0D_FC_AE_CNSTSEL_Q002
	Region	America			Europe				Overall Result
	Customer	FC016 Plaza Mayor		Result	FC001 Anchor Inn			Result
	Calendar Year	2004	Result		2003	2007	Result	Result
Net Sales Europe	Anchor Inn				2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSC				2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSE	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	All Customers (Anchor Inn, Plaza, Bennati)				2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
Net Sales Europe with CSC	Anchor Inn			7.00 EUR	2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSC		7.00 EUR	7.00 EUR	2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSE	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	All Customers (Anchor Inn, Plaza, Bennati)			7.00 EUR	2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
Net Sales Europe with CSE	Anchor Inn	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSC	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSE	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	All Customers (Anchor Inn, Plaza, Bennati)	12.00 EUR	12.00 EUR	12.00 EUR	12.00 EUR	12.00 EUR	12.00 EUR	12.00 EUR	12.00 EUR
Net Sales	Anchor Inn				2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSC				2.00 EUR	5.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	Anchor Inn with CSE	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR	7.00 EUR
	All Customers (Anchor Inn, Plaza, Bennati)	3,00 EUR	3,00 EUR	3,00 EUR	2.00 EUR	5.00 EUR	12.00 EUR	12.00 EUR	12.00 EUR

In the global filter, the query only contains the customers Anchor Inn and Plaza Mayor.
The outer structure contains key figures with filters on the region; either without constant selection (Net Sales Europe, Net Sales), with constant selection on characteristic Region (Net Sales Europe with CSC), or with constant selection on the structure element (Net Sales Europe with CSE).
The inner structure contains filters on the customer, either without constant selection (Anchor Inn, All Customers), with constant selection on characteristic Customer (Anchor Inn with CSC) or with constant selection on the structure element (Anchor Inn with CSE).
All cells in which either the structure element of the outer structure or of the inner structure has the property Constant Selection on the structure element (CSE), are completely constant and are thus completely independent of the drilldown. For structure element 'All Customers' in combination with CSE, the data for customer Banquetes Bennati Ltd. also appear in the total.
All cells that have only activateed constant selection on the characteristic (CSC) either on the region or the customer or on both, are not constant in terms calendar year, meaning that there are detailed values for the calendar year.

Example 2: Query with two structures and empty cell with constant selection on the characteristic (CSC)

Example with Empty Cell

Query 0D_FC_AE_CNSTSEL_Q003
Customer	Calendar Year	2003	2006	2007
FC001 Anchor Inn	Net Sales Bennati 2006
	Net Sales 2003–2007 Anchor Inn	2.00 EUR		5.00 EUR
	Net Sales Banquetes Bennati Ltd CSC			3,00 EUR
FC002 Banquetes Bennati Ltd	Net Sales Bennati 2006		2.00 EUR
	Net Sales 2003–2007 Anchor Inn
	Net Sales Banquetes Bennati Ltd with CSC		2.00 EUR

With the cross-drill, query 0D_FC_AE_CNSTSEL_Q003 creates graphic cells for the characteristic combination (Banquetes Bennati Ltd, 2007), as the value 2007 arises from structure element 'Net Sales 2003-2007 Anchor Inn' and the value Banquetes Bennati Ltd arises from structure element 'Net Sales Bennati 2006'.
The characteristic combination (Banquetes Bennati Ltd, 2007) does not contain any data for structure elements without constant selection, with the result that no data is displayed for structure element 'Net Sales Banquetes Bennati Ltd CSC' with this combination either.

Modified Example with Filled Cell

Query 0D_FC_AE_CNSTSEL_Q004
Customer	Calendar Year	2003	2006	2007
FC001 Anchor Inn	Net Sales Bennati 2006
	Net Sales 2003–2007	2.00 EUR		5.00 EUR
	Net Sales Banquetes Bennati Ltd CSC			3,00 EUR
FC002 Banquetes Bennati Ltd	Net Sales Bennati 2006		2.00 EUR
	Net Sales 2003–2007		2.00 EUR	3,00 EUR
	Net Sales Banquetes Bennati Ltd with CSC		2.00 EUR	3,00 EUR

Query 0D_FC_AE_CNSTSEL_Q004 contains data for the characteristic combination (Banquetes Bennati Ltd, 2007) for structure elements without constant selection. A value is therefore also now displayed for structure element 'Net Sales Banquetes Bennati Ltd CSC' with the characteristic combination (Banquetes Bennati Ltd, 2007).

Example 3: Query with Constant Selection on the Characterstic (CSC)

The following are example queries:

Query 0D_FC_AE_CNSTSEL_Q005 with Constant Selection on all Structure Elements
Customer	Net Sales Banquetes Bennati Ltd with CSC	Net Sales Anchor inn, Banquetes Bennati Ltd with CSC
FC001 Anchor Inn	5.00 EUR	12.00 EUR
FC002 Banquetes Bennati Ltd	5.00 EUR	12.00 EUR

Query 0D_FC_AE_CNSTSEL_Q006 (= 0D_FC_AE_CNSTSEL_Q005 With an Additional Structure Element Without Constant Selection)
Customer	Net Sales Banquetes Bennati Ltd with CSC	Net Sales Anchor inn, Banquetes Bennati Ltd with CSC	Net Sales Banquetes Bennati Ltd without CSC
FC002 Banquetes Bennati Ltd	5.00 EUR	12.00 EUR	5.00 EUR

Query 0D_FC_AE_CNSTSEL_Q005 only has structure elements with constant selection. This means constant selection creates objects in this case. If a structure element without constant selection is added (as in query 0D_FC_AE_CNSTSEL_Q006, for example), this reduces the result: The 'Anchor Inn' row is then no longer displayed in the enhanced query.

Example 4: Noneffective Constant Selection

Query 0D_FC_AE_CNSTSEL_Q007 generates message BRAIN201 "Property constant selection for element &1 is not necessary". This is because the characteristic of the constant selection (CSC), the calendar year, is not filtered in the query or contained as a free characteristic.