This report shows the dimension business key(s) that could not be found in a specified dimension when a specified staging table was last updated. This report will show null values, blank values, and business keys not found in the dimension.

Objects Included

The following WhereScape RED object types are included in this report:

• Stage Tables

Parameters

This report requires two parameters to be specified:

• Stage Table Name (the staging table to be checked)
• Dimension Table Name (the dimension table of the dimension key in the staging table selected first)

Results

The report contains a list of values not found in the dimension and a count for each value. Each column is sortable by clicking on the appropriate column heading.

Report Example

Sending Results to Microsoft Excel

Right-click the result set and click Output to File to send the results of this report to Microsoft Excel.