Query with Two Structures and Threshold Value Conditions: And/Or Linking

You have defined a query with two structures and now you want to apply conditions with threshold values to it.

You analyze the net revenue for the product Mousepad in relation to the sales channels Fax, Internet and Telephone for the calendar year 2003.

Both Structures of the Query Are Located on the Same Axis, for Example in the Columns:

The Calendar Year/Month characteristic is located in the rows. The following can be found in the columns:

• Structure 1 with the restricted characteristics Fax and Mousepad, Internet and Mousepad and Telephone and Mousepad.
• Structure 2 with the key figure Net Revenue.

Condition: Net Revenue > $ 4,250,000 for Internet and Mousepad

Now you want a query that only shows you the net revenue of the product Mousepad that is greater than $4,250,000 where the product Mousepad was sold over the Internet.

Define the following condition:

1. When you are defining the condition, choose All Characteristics in Drilldown Independent, under Characteristic Assignment.
2. Enter the following condition row:

   Choose the key figure Net Revenue, the structure Internet and Mousepad, the operator greater than and enter 4,250,000 as the value.

All of the rows with a net revenue that is less than $4,250,000 for Internet and Mousepad are hidden in the query.

Condition with Two Condition Rows: Net Revenue > $ 4,250,000 for Internet and Mousepad or Net Revenue < $ 4,800,000 for Telephone and Mousepad

Now you want a query that shows you the net revenue of the product Mousepad, through the sales channel Internet, that is greater than $4,250,000. Also, the query must show the net revenue for Mousepad through the sales channel Telephone that is less than $4,800,000.

Define the following condition:

1. Upon defining the condition, choose All Characteristics in Drilldown Independent, under Characteristic Assignment.
2. Enter the following condition rows:
   • Choose the key figure Net Revenue, the structure Internet and Mousepad, the operator Greater Than and enter 4,250,000 as the value.
   • Choose the key figure Net Revenue, the structure Internet and Mousepad, the operator Less Than and enter 4,800,000 as the value.

The values that are shown in the query fulfill at least one of the two condition rows:

For example, the row for 08.2003 is displayed although the value of the net revenue for the sales channel telephone exceeds $ 4,800,000. But, because the condition row for the sales channel Internet (revenue > $ 4,250,000) applies, it is displayed in the query.

The condition rows are linked logically with OR and the system displays the union of the condition rows.

Two Conditions: Net Revenue > $ 4,250,000 for Internet and Mousepad and Net Revenue < $ 4,800,000 for Telephone and Mousepad

Now you want a query that includes two conditions: On the one hand, you only want to see the net revenue of the product Mousepad through the sales channel Internet that is greater than $4,250,000. On the other hand, you only want to see the net revenue for Mousepad through the sales channel Telephone that is less than $4,800,000.

Define the following conditions:

• Net revenue > $ 4,250,000 for Internet and mousepad: see above
• Net revenue < $ 4,800,000 for telephone and mousepad.
  1. Upon defining the condition, choose All Characteristics in Drilldown Independent, under Characteristic Assignment.
  2. Enter the following condition row:

     Choose the key figure Net Revenue, the structure Internet and Mousepad, the operator Less Than and enter 4,800,000 as the value.

The values that are shown in the query fulfill both conditions:

Only the values for the months of April and December 2003 fulfill both conditions.

Multiple Conditions in a query are linked logically with AND if the conditions are active and applicable. The system shows the intersection of the two conditions.

Both Structures of the Query Are Distributed on Both Axes. One Structure Is Located in the Columns and the Other Structure Is in the Rows.

Structure 1 with the restricted characteristics Fax and Mousepad, Internet and Mousepad and Telephone and Mousepad is located in column 1. The following can be found in the rows:

• the characteristic Calendar Year/Month
• Structure 2 with the key figure Net Revenue.

If you now apply the two conditions, Net Revenue > $ 4,250,000 for Internet and Mousepad and Net Revenue < $ 4,800,000 for Telephone and Mousepad, to the query, you get the same result as in the example above, except that the layout is different.