Show TOC

Example 1: Query with Two Structures and a Combination of CSE and CSCLocate this document in the navigation structure

Table 1: 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
Net Sales Europe Anchor Inn EUR 7.00 EUR 7.00 EUR 7.00 EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSC EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSE EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00
All Customers (Anchor Inn, Plaza, Bennati) EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Net Sales Europe with CSC Anchor Inn EUR 7.00 EUR 7.00 EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSC EUR 7.00 EUR 7.00 EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSE EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00
All Customers (Anchor Inn, Plaza, Bennati) EUR 7.00 EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Net Sales Europe with CSE Anchor Inn EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSC EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSE EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00
All Customers (Anchor Inn, Plaza, Bennati) EUR 12.00 EUR 12.00 EUR 12.00 EUR 12.00 EUR 12.00 EUR 12.00 EUR 12.00 EUR 12.00
Net Sales Anchor Inn EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSC EUR 2.00 EUR 5.00 EUR 7.00 EUR 7.00 EUR 7.00
Anchor Inn with CSE EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00 EUR 7.00
All Customers (Anchor Inn, Plaza, Bennati) EUR 3.00 EUR 3.00 EUR 3.00 EUR 2.00 EUR 5.00 EUR 12.00 EUR 12.00 EUR 12.00
  • 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 appears in the total.

  • All cells that have only activated 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.