Query with Condition and Results Row Suppression

In queries that have a condition that is active for a characteristic, and at the same time, the property Suppress Results Row is active for another characteristic, the result will generally be an incomprehensible output list.

You have the following example query in which you are analyzing the net revenue 2001 of your products in relation to your customers:

Activate the property Suppress Results Rows for the Product characteristic. For more information, seeProperties of the Characteristic.

The results rows are hidden:

Now you are interested in every 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 conditioning row:

   Choose the structure Net Revenue 2001, the operator greater than and enter 350,000 as the value.

You will see the following output list:

The output is incomprehensible because the condition refers to the Customer characteristic and the values that the system evaluates in relation to the condition are the values in the results row in this drilldown. Because you activated the property Suppress Results Rows at the same time, it is not clear how this output list is created.

If you deactivate the property Suppress Results Rows in the properties of the Product characteristic, you get the following output list:

Here you see the connection and the reason why the values for the Dawson Agency customer are being displayed. The condition refers to the Customer characteristic and the results row shows that only this customer fulfills the condition.

In extreme cases, the simultaneous use of a condition and results row suppression in a query can lead to incomprehensible results. If you define the condition for All Characteristics in Drilldown Independent for this query now, the system will find no data and you will get an error message.

You have the query displayed above. Now, activate the property Suppress Results Rows for the Product characteristic and the Customer characteristic.

You will see the following output list:

Define the following condition:

1. When you are defining the condition, choose All Characteristics in Drilldown Independent, under Characteristic Assignment.
2. Enter the following conditioning row:

   Choose the structure Net Revenue 2001, the operator greater than and enter 350,000 as the value.

You get an error message saying that the system found no data. The system cannot find any data in this case because you defined the condition for all characteristics in the drilldown independently.

Rule 5: Condition for all characteristics in the drilldown independent and results row suppression

If a condition For All Characteristics in Drilldown Independent is active in a query and results row suppression is active for some characteristics, the system still generates all results and applies the condition(s) to each of these results levels according to rule 4(setting All Characteristics in Drilldown Independent) .

If you deactivate the results row suppression on Product and Customer and also deactivate the condition, then you will get the query displayed above, which looks like this:

The results row, which refers to the customer Dawson Agency Inc., fulfills the condition. The values for Dawson Agency Inc., however, are not displayed, because the condition for All Characteristics in Drilldown Independent has been defined. The system applies the condition to the Product characteristic. If you now choose Swap Customer with Product in the context menu, you will get the following output list:

Here you see that none of the results rows fulfill the condition. All products have a net revenue that is less than $350,000.

In this case, the system considers both results levels in the setting All Characteristics in Drilldown Independent. For the Customer characteristic, a characteristic value passed the test for the condition, that is, Dawson Agency Inc. For the Product characteristic, however, none of the characteristic values passes the test. The system does not find any applicable data and relays an error message.