This report shows dimension tables used by each fact and aggregate table in the metadata as a matrix.

Objects Included

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

  • Dimension Tables
  • Fact Tables
  • Aggregate Tables

Parameters 

There are no parameters for this report.
Results
The results of this report are displayed as a list of refreshed objects in the metadata repository with the following columns:

  • Dimensions (the dimension name)
  • Fact/Aggregate Table 1
  • Fact/Aggregate Table 2
  • Fact/Aggregate Table n

The cells in the cross tab have a 1 to indicate the dimension is used by the fact or aggregate table and blank otherwise. The result set is not sortable.
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.
 

  • No labels