Data Configuration: OLE DB Column View

After you have specified the query name and SQL statement in the Query View dialog, click the Edit button to display the OLE DB Columns options.

Name. Displays the name for the selected column in the query.

Type

Displays the data type for the selected column in the query.

Note. The Type is obtained from the database you are connecting to and cannot be edited. The Target Name, Target Type, Auto update status, and Crosstab property are also listed for each column in the query and can be updated.

Target

 The name of the variable is displayed: 1) to users when filtering options are displayed when this Data Configuration is executed, and 2) in the Statistica data file for an individual column.

Target Type

Target types are configuration settings at the column level to allow Statistica to "know" how to utilize the values in that column. The different target types are presented in a drop-down list box.

Auto Update

Indicates whether a column will be used for the purposes of auto-updating or real-time transferring of data from the external database into Statistica. If so, it indicates the precedence accorded to that column in the auto update process.

By identifying that a column is an auto update column, it also allows Statistica to "know" when a sample is new. This is important when performing alarm checking in QC Analysis Configurations. Without a column identified as auto-updating, all samples would seem to be new samples as there would be no way to identify new samples specifically.

Crosstab

Used for crosstab queries; see the Crosstab Example for more details about crosstabulation options.

Filtering. When the Data Configuration is executed, users optionally can be prompted to filter on specific columns in the Query(ies). These options are set per column, with the default set such that all columns are "non-filterable." Click the Filtering button to display the Filtering Options in the properties page for the setting of whether users may filter on the respective column.

SQL Information

For most applications, this information is provided by the OLE DB provider (e.g., SQL Server and Oracle) for the database being queried. For those circumstances in which the OLE DB provider does not return the table name, schema name, and catalog name, ambiguities may arise in the SQL statements generated. In the rare cases in which it is necessary to do so, click the SQL Information button to display the SQL Information options in the properties page.

Additional options that may be displayed depending upon the Target Type (see option description above) specified:

Defects Lookup SQL Statement

(This option group is displayed when the Target Type is Attribute Characteristic.) Use these options to retrieve the specifications for this characteristic from an external database (e.g., a table that contains the specifications for your products/parts/processes) or to set them as constant values manually.

SQL Wizard

Click this button to build a SQL statement to retrieve specification information for the current characteristic. This button will display the New Query dialog for the user to build the SQL specification information query. The query should return a single row of values to be used as specifications.

Specification Type

(This drop-down list box is displayed when the Target Type is Specification.) Select the appropriate type that corresponds to the values in the selected column (e.g., Sigma, Center Line, UCL, LCL).

The following specification types can be selected: Center Line, LCL, Lower Warning Line, Range Center Line, Range LCL, Range Lower Warning Line, Range UCL, Range Upper Warning Line, Sigma, Specs Delta, Specs Lower, Specs Nominal, Specs Upper, UCL, and Upper Warning Line.

Associated with. These options for OLE DB Columns of Specification Target Type can be associated to all characteristics within the query or to specific one(s).

All characteristics within the query

Select this option button to associate this characteristic to all characteristics within the query.

Below characteristic(s)

Select this option button and select from the available list of characteristics to associate this specification to the specific characteristic(s).

Enable set identification

(This check box is displayed when the Target Type selected is Set Identifier.) Select this check box in order to use set information for this query. Set Identifiers are used when the Analysis Configuration to be used is type "IQC" for Quality Control charts analysis. In the Statistica Quality Control module, sets are a collection of samples that have the same control or specification limits. Sets can be defined prior to the analysis (on the Sets tab of the Defining Variables dialog box) or after the initial charts have been created (on the Sets tab of the Results dialog). A Set Identifier column is a categorical variable that indicates set membership, or the data can contain the specifications and/or control limits for each sample. All samples that have the value for the Set Identified columns will belong to the same set.

Calculate sigma from the first k samples in the set.; k =

(This text box is displayed when the Target Type selected is Set Identifier.) Enter the value for k. When sigma is calculated for the Set, only the first k samples will be used in the calculation. For example, the Set may have 20 samples, but if k=10, only the first 10 samples will be used in estimating sigma. That estimate of sigma will be applied to all samples in the respective Set. If this check box is cleared, all values in the Set will be used in calculating sigma for each respective Set.