Query with Two Presentation Hierarchies and Conditions

You analyze the net revenue for your products in relation to your customers.

You have defined the following query:

Both the Customer and the Product characteristics are located in the rows and the columns contain the key figure Net Revenue. You are also using active presentation hierarchies on both characteristics.

Caution

Note that a scaling factor of 1000 is being used in this example query. The values in the condition definition refer to the actual values because the scaling factor is not considered in the evaluation of the condition. In the query, the values are displayed with a scaling factor of 1000. For more information, seeBackground Information on Conditions.

The query looks like this:

Threshold Condition for the Customer Characteristic

Now you want to see each customer that has a net revenue of more than $350,000. Define the following condition:

When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.
Select the Customer characteristic.
Enter the following condition row:
Choose the structure Net Revenue, the operator greater than and enter 350,000 as the value.

In the query, you see the customer Dawson Agency Inc and the nodes Regular Customers and Non-Assigned.Customers, each of which has a net revenue of greater than $350,000.

For example, if the node Non-Assigned Customers does not fit the condition due to the inclusion of negative single values, it will still be displayed. This is necessary, because otherwise the customer Dawson Agency Inc. could not be classified. As a result, the system ensures that the business context of the query remains visible after a condition has been applied.

Rule 10: Display of Hierarchy Nodes

If a threshold value condition is applied to a characteristic with an active presentation hierarchy, then a node that actually does not fulfill the condition and would normally be filtered out is shown anyway if at least one of the subordinate nodes fulfills the condition.

If you drilldown the Product characteristic in the columns now, then the query will appear as follows:

Threshold Condition for Characteristic Combination Customer/Product

Now you only want to see all customer/product combinations that have a net revenue of more than $100,000.

Define the following condition:

When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.
Select both Customer and Product characteristics.
Enter the following condition row:
Choose the structure Net Revenue, the operator greater than and enter 100,000 as the value.

In the query, you only see combinations of Product and Customer that have a net revenue of more than $100,000. The condition here refers to the characteristic combination. All values for the net revenue are greater than $100,000. Only products and customers are displayed that fit the condition.

The system proceeds as follows:

First the condition is checked for the innermost characteristic with the singe values and then the superordinate values.

Ranked List Conditions

For example, if you want to see the five customers with the highest revenues on this query with both active presentation hierarchies and you defined a ranked list condition for it, you will get a not applicable status description from the system.

Rule 7: Ranked Lists on Characteristics with Active Presentation Hierarchy Not Possible.