DataFlux Data Management Studio 2.6: User Guide
You can use the Report tab in the Profile dialog to specify reporting methods for tables and fields that were selected in the Properties tab. You can use the toolbar at the top of the tab to perform the following functions:
The information displayed on the left varies according to the riser bar selected on the right side. The Tables Riser Bar is selected by default. In this case, the Tables tree contains folders for the databases and tables that were selected on the Properties tab.
If you select an object in the Tables tree, information about that object will be displayed on the right. If you click a table, its fields are displayed in a table. The table contains fields for the metrics that you enabled on the Properties tab. Note that the sub-tabs from the Properties tab are displayed above the rows of the table. If you have enabled any of these functions, you can click the sub-tab to access the results.
You can also open the Notes sub-tab to review any notes entered about the table and its profile. A note that you add to the Notes sub-tab is associated with a specific report instance and not with the underlying profile. Therefore, the note will not be associated with any other report instance.
You can also click a field in a table. The right side of Profile dialog displays detailed information about metrics run for the selected field. This information is divided in categories that are represented by a series of sub-tabs. The following categories are available:
Of course, you can only see data for the categories that you have configured for profiling. If you see the text (Not calculated) in a sub-tab, check your configuration on the Properties tab.
You can right-click a field in a table to select from the following pop-up menu items:
For more information about these metrics, see Metrics Dialog.
The Collections Riser Bar displays any collections that contain fields that are included in the profile. If you click on the collection, you see a table that includes all of its fields, just as you would with a table when you select the Tables Riser Bar. Similarly, when you select a field in a collection, you see the same display that appears when you select the same field in the context of the table that contains it.
The Redundant Data Analysis Riser Bar is used to complete a redundant data analysis that you have configured on the Properties tab. If you have not configured this analysis, the right side of dialog displays as a blank screen.
See also the profile performance tips in Jobs, Profiles, Data Explorations.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_ProfileReport.html |