DataSet Properties - Datasource Tab

Topic Contents: Hide

 

The DataSource tab is used to link specific Feature and Sample data to a DataSet. The DataSet will use data from a specified routine, features, and samples, or from another DataSet. Click on the image below for more information on the various regions of the DataSource Tab.

Query

The Query section allows you to select which query you want to pull data from to use in the DataSet.

·        Active - The currently active query will be used.

·        Query - Select the Query you want to use from the menu. Queries will appear in the menu in the order they were loaded.

Feature

Select the feature or features you want to use in your DataSet from the Feature section of the dialog.

·        None - No features will be loaded into the DataSet.

·        Feature - Select a single feature from a menu containing all of the features in a selected query.

·        List - Allows you to create a custom a list of features to use. Click Edit to open the Feature List dialog, then add the features you want to use in the DataSet. To select multiple features, hold down the shift key while selecting a range of features, or hold down the ctrl key and click on individual features.

§         - Moves the selected features from the Available Features section to the Features in List section on the left hand side. You must select at least one row for the button to be active.

§         - Moves the selected features from the Features in List section to the Available Features section on the right hand side. You must select at least one row for the button to be active.

§        Select All - Selects all of the features in the section on the side corresponding to the button used.

§        Select Set - If you have any Feature Sets, choose one from the dropdown menu and click Ok. All features included in the selected feature set will be loaded into the Available Features section of the Feature List dialog.

§        Move Up - Moves the selected feature up one row in the Features in List section.

§        Move Down - Moves the selected feature down one row in the Features in List section.

§        Fix - If a feature does not resolve, an alternate feature (in a different Routine) may be suggested, based on the feature label. To accept the suggested Alternate feature(s), click Fix.

§        Set - Choose a previously created Feature Set from the menu.

§        All Features (In Query) - Uses all of the features available within the routine selected when you assigned features to a query.

§        Use Only Feature # - Selecting Use Only Feature # will load only the feature selected.

Sample

Select a specific sample or group of samples.

·        Active - Uses the active sample.

·        Last - Uses the last sample loaded into the query.

·        Sample - Select which sample to use from a list of all samples available within the selected query.

·        All Samples (In Query) - Uses all of the samples in the selected query.

·        Use Only Sample # - A single sample can be selected by position number within the routine load by selecting the Use Only Sample # check box and entering the sample position in the number fields. Entering a range of numbers in these fields allows for the samples within the position interval to be loaded.

DataSet

When a DataSet is created or edited, a DataSource is defined for it in the DataSet Properties DataSource tab. If a different DataSet is selected from the dropdown, then all other DataSource properties (i.e. Query, Feature, and Sample) are ignored.

·        None - If you wish to specify the DataSource using the routine, feature, and sample properties on this page then select the None radio button here.

·        DataSet - To select another DataSet to use as a DataSource, pick a DataSet label from the dropdown list.

·        Use All Rows - To select All Rows from the selected Database, click the radio button next to Use All Rows. The DataSet properties may be accessed by clicking Modify to the right. Any changes made here will have the same effect as if it were modified through the DataSet tree.

·        Use Row # - To select a specific row or a range of rows, select the radio button next to Use Only Row # and enter the row number(s) in the field(s) (e.g. 2 Thru 12).

·        Use Feature - The rows from the DataSet to be used may be selected using the feature label and characteristic association in combinations such as x dev, y dev, etc. The Use Feature for Characteristic option is populated at the time the DataSet is selected from the menu.

DataStack

The DataStacks section of the DataSource tab is used to set up which calculations you would like to perform on a specified set of data.

·        None - If None is selected, DataStacks will not be used.

·        Merge - Merge allows you to combine all the DataSets of your DataStack in one of three ways: Append, Collate, or Subset.

·        3D Math - The selected 3D Math calculation is performed on the DataStack.

·        Statistics - The selected Statistics are applied to the entire DataStack.

·        Evaluation - The selected Evaluation method is applied to the DataStack.

·        DataSets... - Once you have selected method you want use to synchronize your DataSets (Merge, 3D Math, Statistics, or Evaluation), select DataSets... to select which DataSets you want to include in the DataStack.

·        Setup... - Setup... may be accessed when some combinations of settings are selected in the DataStack section.

Effective Dates

Under Effective Dates on the DataSource tab of the DataSet Properties dialog, there are three available effective date settings:

·        Automatically determine applicable effective date - Allows CM4D to use a sample's effective dates to determine how the sample will be applied to process baselines. The samples are organized into process baselines by comparing the effective date of each sample to the date of the process baselines. This is the only effective date option that uses a sample's effective date, and will result in sample data that is divided over more than one process baseline.

·        Use most recent effective date - Forces samples to associate to a single process baseline. The result will be that each sample's effective date will be ignored, and the newest process baseline will be used (including the newest engineering and control data).

·        Use - Enter a specific date. to forces samples to associate to a specific process baseline. The result will be that each sample's effective date will be ignored, and CM4D will use the process baseline that has an effective date equal to or earlier than the user-specified date by searching backwards from the date entered in the field.