Ranked List Condition for All Characteristics in Drilldown Independent: Top 3 Products and Top 3 Sales Channels 

You want to see a query in which the top 3 net revenue generating products are displayed. You also want to see the top 3 sales channels for these products.

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 operator Top N and enter 3 as the value.

In the query, put the characteristics Product and Sales Channel into the drilldown. The query now displays the top 3 products and the associated top 3 sales channels:

The sum in the overall result is calculated locally using the function Calculate Results as Sum in the above example.

In this case, the system first determines the top 3 products and then the top 3 sales channels for each of the three products. In total, in addition to the three results rows and the overall results row, nine rows are displayed.

You now want to see the Top 3 sales channels with which you have had the largest net revenue and the top 3 products for each one.

In the context menu, choose the function Exchange Sales Channel with Product. The required query view then appears:

The sum in the overall result is calculated locally using the function Calculate Results as Sum in the above example.

First the system determines the top 3 sales channels, and for each of these three sales channels, it determines the top three products.

You can use the same condition for both queries as the condition is defined independently for all characteristics in the drilldown.

Rule 4: Setting All Characteristics in Drilldown Independent

The setting All Characteristics in Drilldown Independent means that each characteristic of the drilldown has a condition (identical) defined for it These conditions are linked with AND according to rule 2 (linking of multiple conditions).

A condition that is independently defined for all characteristics in the drilldown can be used everywhere. It generates different results for different queries.

The definition of the condition with the setting All Characteristics in Drilldown Independent returns the same result as the definition of conditions for each separate characteristic. In this example, you can also define one condition for Sales Channel and one for Product to answer the same query.

·        You could define the following condition for Sales Channel:

                            a.      When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.

                            b.      Select the Sales Channel characteristic.

                            c.      Enter the following condition row:

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

·        You could define the following condition for Product:

...

                            a.      When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.

                            b.      Select the Product characteristic.

                            c.      Enter the following condition row:

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

In the query, you need to actively set both conditions to get the same results as displayed above.

The setting All Characteristics in Drilldown Independent is more efficient in this case and allows you to easily use the condition in a very general way. In this example, you do not need to define a condition for each characteristic to make the condition apply to all characteristics individually.