Query with Two Structures and Ranked-List Conditions 

You have defined a query with two structures and now you want to apply conditions with ranked lists 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.

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.

All Characteristics in Drilldown Independent

Condition: Top 4 for Internet and Mousepad

You want a query that shows you the four months with the highest revenue in regard to sales of the product Mousepad over the Internet.

Define the following condition:

       1.      In the dialog box, choose Defining a Condition in the Evaluation of Conditions Below for all Characteristics in Drilldown Independently.

       2.      In the field Display all Values for which at least one of the following conditions are valid, enter the following condition line:

Choose the key figure Net Revenue, the structure Internet and Mousepad, the operator Top N and enter 4 as the value.

In the query, you only see the rows with the four months with the highest revenue for Internet and Mousepad.

Characteristic Combination

Now you want to determine net revenue by customer and so, in addition to the Calendar Year/Month characteristic, you include the Customer characteristic to the lines of the query.

Condition: Top 3 Combinations of Calendar Year/Month and Customer

You would like a query that shows you the three customer/month combinations that have the highest revenue out of all of the possible combinations of the two.

Define the following condition:

...

       1.      In the dialog box, choose Defining a Condition in the Evaluation of Conditions Below for Single Characteristics and Characteristic Combinations.

       2.      Select the characteristics CalYear/Month and Customer.

       3.      In the field Display all Values for which at least one of the following conditions are valid, enter the following condition line:

Choose the key figure Net Revenue, the structure Internet and Mousepad, the operator Top N and enter 3 as the value.

In the query, you see only the three customer/month combinations with the highest revenue for sales over the Internet:

Ranked list conditions do not differ in their applicability in queries with two structures from those in queries with one structure.