Data Configuration: Filtering Options

Select this check box to enable filtering and to activate the remaining options in the Filtering Options properties page. If this check box is not selected, this column will not be available in the SQL Criteria dialog.

This group box contains the following options:

This check box controls whether a user sees the list of potential values contained in the column, or is presented with an input box in which to enter the required value. For example, if a label (e.g., such as product type) contains thousands of values, it may not be desirable for the user to see a list of so many values in a drop-down list box. If this check box is selected, before the query is run, an input box will be provided in the SQL Criteria dialog from which the user will be able to enter a target value for the label directly.

The SQL statement options are utilized to query the list of values to be displayed for the users' selection at the execution of this Data Configuration during filtering for this respective column.

Click this button to launch STATISTICA Query.

Use these options to define how this column will be filtered in the SQL Criteria dialog.

Select this check box to enable filtering in the SQL Criteria dialog.

Hierarchical Filtering. Hierarchical filtering is the scenario in which users are prompted to filter columns in a specific sequence. The sequence order is specified by the options in this frame. A common scenario for the use of hierarchical filtering is when subsequent filters depend on the selections from a previous sequence (e.g., the Test Codes displayed are dependent on the Product Code selected in the previous screen).

When the Last option button is selected, the currently selected field will be displayed last when the user selects the filtering options at run-time. The Last option button is selected by default.

It may be necessary that a user of this query must interactively filter by multiple columns' values when an Analysis Configuration based upon this Data Configuration is run. For example, consider a circumstance in which a variety of products are manufactured on a number of production lines. A user may first need to filter by line, and then be able to filter only by the products manufactured on the previously selected line. This scenario is possible and is specified using the Sequence Number property of a column. In the previous example, you would specify the column containing line numbers as Sequence Number 1. This specification indicates that it is first in the hierarchy of filtering. The column containing product types would be specified as Sequence Number 2. This specification indicates that product is second in the hierarchy of filtering, such that the available values for product are first filtered by the selected line(s).

When this check box is selected, the current column must be used for interactive filtering before an Analysis Configuration based upon this Data Configuration will be run. Consider the following example: Perhaps your company manufactures many products, with the measurements for each product stored in the same field in the external database. You may want to set up one "general" Data Configuration to return the values contained within that field for a given time period. If the user does not interactively filter by product, however, measurements for several products will be plotted on the same chart. To avoid the possibility of charting values for heterogeneous items, selecting this option for a column that contains product values would force the user running the query to filter interactively by product first (i.e., before the measurements are queried and the chart is created). 

When this check box is selected, the criteria for the selected column will be applied to all queries in the current Data Configuration. What this means is that the user will only need to filter on the column once rather than for each Query in this Data Configuration.

Single criterion only. Select this check box to prevent users from specifying more than one filter criterion for a given field during interactive filtering.

The options in this group box control which operators will be available to the user when exploring the Data Configuration, or when running an Analysis Configuration based on the Data Configuration.

Select this check box to make all operators available to the user. Clear this check box to allow the selection of individual operators from the list box below.

This box lists all the available operators.

This box lists all the operators that have been chosen to be made available to the user. Operators can be added or removed using the right and left arrows.