Show TOC

Example 2: Query with Two Structures and Empty Cell for CSCLocate this document in the navigation structure

Example with Empty Cell
Table 1: 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 EUR 2.00 EUR 5.00
Net Sales Banquetes Bennati Ltd CSC EUR 3.00
FC002 Banquetes Bennati Ltd Net Sales Bennati 2006 EUR 2.00
Net Sales 2003-2007 Anchor Inn
Net Sales Banquetes Bennati Ltd with CSC EUR 2.00

  • 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
Table 2: Query 0D_FC_AE_CNSTSEL_Q004
Customer Calendar Year 2003 2006 2007
FC001 Anchor Inn Net Sales Bennati 2006
Net Sales 2003-2007 EUR 2.00 EUR 5.00
Net Sales Banquetes Bennati Ltd CSC EUR 3.00
FC002 Banquetes Bennati Ltd Net Sales Bennati 2006 EUR 2.00
Net Sales 2003-2007 EUR 2.00 EUR 3.00
Net Sales Banquetes Bennati Ltd CSC EUR 2.00 EUR 3.00

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).