Reporting on Model Metadata

How to Generate or View Reports

Your reporting needs could vary from a simple report on a logical model to a complex report on the model metadata. Regardless of your needs, CA ERwin DM provides easy options to generate and view reports on models and metadata of models.

The new reporting tool Report Designer lets you generate a wide variety of reports on the most recent data. Use the Filter By option to drill-down reports to the object level. Apart from this, if you want a standard report, use the predefined (or Pinned) reports. If you want a specific report customized to your needs, generate a custom report.

Use SQL-based reporting tools to query ERwin ODBC and generate custom reports. Use the built-in Query Tool, Business Objects™ Crystal Reports® 2011 that is shipped with CA ERwin DM, or any ODBC-compliant tool. CA ERwin DM Bookshelf includes sample queries that help you with SQL queries for custom reports. Use the queries as they are, or tweak them to suit your requirements. Save your custom queries for future use.

The information you retrieve includes reports on the following:

Objects and properties in your models
Metadata defining model objects and properties
Action log that records the changes made to a model during a session

To use an ODBC-compliant tool, you make use of the data sources created by CA ERwin DM. You must know to write SQL queries.

The following diagram illustrates how you can generate reports on model metadata:

Illustrates the ways in which you can generate reports

Use the following tasks to generate reports on model metadata:

Verify the CA ERwin DM ODBC data source.
Decide the type of report.
Create reports using Report Designer.
View Pinned reports.
Generate custom reports.