Properties

You can use the Properties tab in the Profile window to select data sources and specify metrics to be calculated for these data sources. You can use the toolbar at the top of the tab to perform the following functions:

Note that the File menu for the Properties tab enables you to perform common management functions for an opened profile. For example, you can click Change Description to modify the profile description. When you save the Profile, the new description is updated and stored.

You can use the tree on the left to select data sources and fields for analysis. Expand the top-level folders to display the tables, files, filters, or queries that are associated with each folder. Select a data source to display its fields. Select all data sources and fields that you want to analyze.

You can use the sub-tabs on the right to specify metrics that will be calculated for fields that are selected on the left.

The Fields sub-tab enables you to select or deselect fields to be analyzed.

The Custom Metrics sub-tab enables you to select an existing custom metric and apply it to the selected fields.

The Business Rules sub-tab enables you to select an existing rule and apply it to the selected fields.

The Alerts sub-tab enables you to select an existing alert and apply it to the selected fields.

The Visualization sub-tab enables you to select a visualization and apply it to the selected fields. Visualizations are custom charts that you can create to provide a graphical view of the data.

You can select a table in the Table tree. Then, you can right-click it to perform the following functions:

Insert Filtered Table - Enables you to access the Filter on Table dialog, which you can use to filter the data that the table contributes to the query.

Insert SQL Query - Enables you to create a query with the Query Builder dialog.

Insert Text Field - Enables you to insert a text field.

Sample Interval - Enables you to specify a sample interval, which reduces the number of rows used for the profile. For example, you can sample every 5 rows to only include every fifth row.

Open - Opens the Table View for the selected table.

You can also select a field. Then, you can right-click it to perform the following functions:

Override Metrics - Enables you to add or remove items from the list of metrics used when you run the profile. After you have overridden the metrics for a field, you can right-click it again to edit or remove the metrics overrides.

Primary Key/Foreign Key Analysis - Selects the field for use in primary and foreign key analysis.

Redundant Data Analysis - Selects the field for use in redundant data analysis.