You can access the VisualSPC data source configuration windows in the following ways:
When an object is inserted from the Insert menu (in the configuration environment). In the Configuration panel, access the Data tab and set the data source via the Data Source Browser. Refer to The Data Source Browser for more information.
NOTE: The VisualSPC data source is located under the Quality node of the Data Sources tree.
When an object is inserted with the drag-and-drop method (Natural Presentation), either in the configuration or run-time environments. Refer to Dragging and Dropping Data Sources (Natural Presentation) for more information.
When an object is modified (either from the Configuration dialog box), or in the case of Quality (SPC) charts in run-time, the context (right-click) menu Edit Data Source option.
The configuration options will vary depending on whether parts or characteristics are used. Select the procedure specific to your needs:
Configure for Parts | Configure for Data Tables | Parts Field Descriptions | Data Table Field Descriptions
Select All, By Last n Subgroups, Use Summary Statistics, or By Date/Time for the method of database query.
If you select By Last n Subgroups, enter the number of subgroups to be returned by the database query.
If you select Use Summary Statistics, then source data from the FirstSGDateTime to the LastSGDateTime is returned for a specific station. This option is useful when you are linking data from a Summary Statistics grid (data is filtered based on the statistics window Date/Time). Since Summary Statistics are calculated based on each individual Station, if this option is selected without being linked with ID, you must specify a Station filter to ensure the most current window from that station is being used. If the Station filter is not specified, the first StationName is used.
If you select By Date/Time, you must also select Absolute, Relative, or Range and the associated values in the Start/End or Range fields.
To set a filter, from the Where list box, select the category name you want to filter by.
From the Relationship list box, select the operator to use for the filter you want to set.
From the Value list box, select the category value to use for the filter, or select the Constant check box and enter a value (the Value list box changes to a text box).
Click the Add button to add the filter you have configured.
Click OK (or Finish in Natural Presentation).
The Configure New Object (VisualSPC) dialog box has the following fields:
If you are configuring a Characteristics Data Table:
Select the characteristic type (All, Attribute, Defect, or Variable). This will depend on what the characteristic table is being used for. For example, if you want to use the characteristic table with a parts source that is Variable, you should choose the Variable option.
Select the Data Column for the characteristic table (ID, PartCharID, or None). This will also depend on what the characteristic table is being used for. For example, if you insert a grid and select the PartCharID column, the grid will display data for the CharacteristicName and PartCharID columns.
Enter filters for Station and/or Part Name, as required. Filtering is optional. For an example of the types of filter expressions that can be used, see Filtering.
Click OK (or Finish in Natural Presentation).
If you are configuring a Parts Data Table:
Enter filters for the Station and/or Part Name Filter, as required. Filtering is optional. For an example of the types of filter expressions that can be used, see Filtering.
Click OK (or Finish in Natural Presentation).
If you are configuring a Stations Data Table:
There are no input parameters associated with Stations, and therefore, configuration is not required.
Click OK (or Finish in Natural Presentation).
If you are configuring a Summary Statistics Data Table:
Enter the filters for Station Filter/Part Name Filter and/or Characteristic Name Filter, as required. Filtering is optional. For an example of the types of filter expressions that can be used, see Filtering.
Click OK (or Finish in Natural Presentation).
|
Property |
Description |
|
Characteristic Type Selection |
Applies only to characteristic data tables. Indicates the type of data the table will be used with.
|
|
Data Column |
Applies only to characteristic data tables. Indicates the data column that will be used (in addition to the CharacteristicName column).
|
|
Filter Parameters |
Applies to all Data Tables except Stations. Depending on the types of default parameters that are used, these fields allow you to enter expressions for filtering data. For more information, see Filtering. |
