Show TOC

Query with a Presentation Hierarchy and ConditionsLocate this document in the navigation structure

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 an active presentation hierarchy for the Customer characteristic.

Caution

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 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:

  1. When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.
  2. Select the Customer characteristic.
  3. 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 fulfill 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 for the end user 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, a node that does not actually fulfill the condition and would normally be filtered out is shown anyway, if at least one of the subordinate nodes fulfills the condition.

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:

  1. When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.
  2. Select both Customer and Product characteristics.
  3. 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. Here the condition refers to the characteristic combination. All values for the net revenue are greater than $100,000. Only products and customers are displayed that fulfill 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 the active presentation hierarchy and you defined a ranked list condition for it, the system will return a Not Applicable status description.

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

See also:

Using Conditions