Query with Hierarchically Displayed Axis and
Conditions 
You are analyzing the net revenue of your products in relation to your customers.
You have defined the following query:
The characteristics Customer and Product are located in the rows and the columns contain the key figure Net Revenue. You have activated the function Display as Hierarchy in the rows so that the axis is displayed hierarchically.
Note that a scaling factor of 1000 is used in this example query. The values in the condition definition refer to the actual values because the scaling factor is not taken into consideration during evaluation of the condition. In the query, the values are displayed with scaling factor 1000. You can find more information under Background Information on Conditions.
The query then appears as follows:
Threshold Value Condition for the Customer Characteristic
Now you want to only see customers who have net revenues greater than $350,000. 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 field.
2. Select the Customer characteristic.
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 operator greater than and enter 350,000 as the value.
In the query, you only see the customer Dawson Agency Inc, with net revenues greater than $350,000.
Ranked List Condition for the Customer Characteristic
You want to see three customers with the highest revenues. 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 field.
2. Select the Customer characteristic.
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 structure Net Revenue, the operator Top N and enter 3 as the value.
You see the three customers with the highest revenues in the query:
The threshold value condition and the ranked list condition in the examples above each refer to the Customer characteristic. With queries with hierarchically displayed axis, threshold value and ranked list conditions are always possible up to the last characteristic to which you have expanded the hierarchical display. In the examples above, the Customer characteristic is the outermost characteristic, which is why the condition works. For example, if you now define a condition for the Product characteristic, in the context menu for the corresponding axis (in this case, the rows) you have to set Expand to <Product> in the Query Designer. You also have the option of making this setting on the Web during runtime. In the context menu for the Web application, choose Properties of the Query and make the appropriate setting under Preparation of the Data (see Properties of the Query).
Also note that manually expanding the appropriate nodes at runtime is not sufficient. The drilldown level must be set using the Expand to so that the condition can be applied.
Ranked List Condition for the Product Characteristic
You want to see two products with the highest revenues. In the Query Designer, you choose Expand to Product in the context menu for the rows and 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 field.
2. Select the Product characteristic.
3. In the field Display all Values for which at least one of the following conditions is valid, enter the following condition line:
Choose the structure Net Revenue, the operator Top N and enter 2 as the value.
In the query, you see the two products per customer with the highest revenues:
Threshold Condition for All Characteristics in Drilldown Independent
You want to see all customers and the associated products that have net revenues greater than $ 100,000. In the Query Designer, you choose Expand to Product in the context menu for the rows and 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 is valid, enter the following condition line:
Choose the key figure Net Revenue, the operator greater than and enter 100,000 as the value.
You want to see all customers and products that have net revenues greater than $ 100,000:
Ranked List Condition for All Characteristics in Drilldown Independent
You want to see the two customers with the highest revenue and the two associated products with the most revenue. In the Query Designer, you choose Expand to Product in the context menu for the rows and 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 operator Top N and enter 2 as the value.
You see the two customers with the highest revenue and the two associated products with the highest revenue.
Ranked List Condition for the Customer/Product Characteristic Combination
If you now want to define a ranked list condition for the Customer/Product characteristic combination (e.g. Top 3 customer/product combinations), you will get a not applicable status description from the system. Ranked list conditions are not possible for characteristic combinations in a query with hierarchically displayed axis.
See also: