This report is useful when you know the database name of the view and wish to know the fields in that view. Click here for a list of useful and commonly used views.
Start by creating a User Report Type with:
Base Table = Data Dictionary Field and
Data Source = Data Dictionary Table with the path Data Dictionary Field->Data Dictionary Table
Next create a User Report using the User Report Type "Data Dictionary Fields". Configure the report to include the following:
Data Fields: Data Dictionary Table: Name; Data Dictionary Field: Column Name and Data Dictionary Field: Unique Name
Filters: Data Dictionary Table: Name - include this as a prompt.
When running the User Report, enter the database name of the view. Click here for a list of useful and commonly used views including the view's name in the database.
Here are the results of the user report.
