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.