This report lists objects in the metadata repository with Extended Properties defined.

Objects Included

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

• Connections
• Load Tables
• Stage Tables
• Data Store Tables
• Hub Tables
• Link Tables
• Satellite Tables
• EDW 3NF Tables
• Dimension Tables and Views
• Fact Tables
• Aggregate Tables
• Join Indexes
• Views
• Exports

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:

• Object Name
• Variable Name (The unique variable name in the format it is accessed from the RED metadata service and included in scripts)
• Display Name (The extended property name displayed in the Connection or Table properties)

The result set 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.