Your Application Table Column Reports H

NOTE: When a user accesses this page in the Navigation pane, the fields below display. When a user clicks the View icon on this page to view report data, the report title still displays as the page name even though columns that display depend on the columns on the generated report. In this case, the page displays the report’s columns only and not the fields below.

Your Application Table Column Reports V

Use this page to:

To access this page:

  1. Click dspMonitor > Your Applications in the Navigation pane.
  2. Click the Tables icon.
  3. Click the Columns icon.
  4. Click the Reports icon.

Your Application Table Column Reports V

Your Application Table Column Reports H

Use this page to.

This page contains the following tabs:

General tab

Field

Description

Execute

Click to process the report for the logged in user.

Execute For All Users

Click to process the reports for all users who have access to the reports.

Reset

Click to reset running report. Reset report if process backs up due to network problems.

Report Info

Repository

Displays name of database where reports reside.

Group ID

Displays name of group to which the report belongs.

Report

Displays name of report as it appears in the report repository.

Opportunity View

Displays the name of the opportunity view, which contains the full set of possible records that could potentially fail in the associated error report.

NOTE: An opportunity view is only applicable to Error reports.

The opportunity view is used in data quality score calculations. When calculating data quality scores on the Your Groups, Your Objects, and Your Applications summary and report pages, error reports without an opportunity view are not included in the data quality scoring calculations.

The opportunity view must include all required key fields of the error report and any fields needed for user filters.

Quality Dimension

Displays the Quality Dimension, an industry- recognized term used by data management professionals to describe a feature of data that can be measured or assessed against defined standards to determine data quality. Refer to Register Quality Dimensions for more information.

NOTE: dspMonitor™ is delivered with six industry standard quality dimensions: Accuracy, Completeness, Conformity, Integrity, Timeliness and Uniqueness.

NOTE: All Error reports require a quality dimension.

Report Type

Displays the categorization of report. Values are: Error, Information and Metric.

Data Quality Rule

Displays the name of the report.

Implication

Displays description of what the report means to the business.

Comment

Displays comment or description about report.

Scorecard Link

This field is not used.

Where Clause

Displays filter applied to report for user to limit data displayed in report.

Order By

Displays columns by which the report is sorted.

Favorite Settings

Favorite

If enabled, the selected report has been added as a favorite report and displays on the Your Favorite Reports page.

Report Generation Info tab

Field

Description

Opportunity Count

Displays the number of records in the opportunity view, which contains the full set of possible records that could potentially fail in the error report.

Defects

Displays the number of errors on the report.

Process Started On

Displays date and time when report started running.

Process Completed On

Displays date and time when report completed running.

Queue

Click to open the Monitor page to view the process queue for reports.

View

Click to view data within report.

Metric Info

Latest Metric Date

Displays date when metrics were last built.

Metrics

Click to open the Your Report Metrics Chart to view a line chart of the report’s record count history and the Your Metrics page to view data about the report, e.g., the last time the report was processed.

Reset Metrics

Click to clear metrics for the report. If the report is run more than once within a 24-hour period, the previous metrics are overwritten.