Working on a Mart › Workgroup Modeling Reports

Workgroup Modeling Reports

Modelers typically work from a common set of libraries and models, and share information about these objects with other users. One way to share information is by using reports, which details the information and definitions for a model. You can generate predefined reports to view the contents of specific libraries and models, view the changes and conflicts for specific models, and view the security structure for the database.

You can generate Mart reports using either the Report Designer or a third-party reporting tool. This section describes the reports that are generated using Crystal Reports.

Report Designer: Report Designer lets you create a wide variety of Mart administrative reports and cross-model reports. You can create report templates for frequently used reports and you can export reports to the HTML, CSV, and PDF formats. You can create report solutions and include multiple report templates. For more information about the Report Designer, see the Online Help.
Reporting Tool: You can create custom reports using a third-party reporting tool. For more information about generating custom reports, see the Creating Custom Mart Reports using a Reporting Tool guide.

erwin® Data Modeler Workgroup Edition includes the following predefined reports:

Global Reports

The following table describes the global reports that you can run against Mart:

Report Name	Description
Attributes By Name	Provides information for a specified attribute name--logical and physical, including its library, and its owning diagrams and entities.
Derived Models	Provides a list of all models that are created using the Derive Model process.
Entities by Name	Provides information for a specified entity name--logical and physical, including library, its owning diagrams, and owned attributes or columns.
Libraries	Provides a list of all libraries in Mart.
Library Model Entity	Provides a hierarchical list of all entities in models and libraries.
Library Model Version	Provides a list of the versions of all models.
Library Model	Provides a list of the models in the selected libraries.
Mart Domains	Provides a list of all domains used by diagrams, sorted by diagram and library. Includes the domain name, domain parent, domain parent name, and domain data type.
Models with Subject Areas	Provides a list of all Subject Areas and the diagrams in each Subject Area in a model.
Models	Provides a list of all the models in the entire Mart. The report includes details such as the number of entities and attributes, and the total number of model objects.
Subject Areas	Provides the list of all subject areas, including subject area members.
User Defined Properties	Provides a list of all user-defined properties for the current open model, including UDP name, class name, and default value.
Users	Provides a list of all users assigned to Mart, including user numeric ID and server login.

Model Validation Reports

The following table describes the model validation reports that can be run against models in the mart:

Report Name	Description
Attributes without Definition	Provides a list of all attributes that have no definition text for the specified model.
Attributes without Domains	Provides a list of all attributes that have no domain association for the specified model.
Entities whose Primary Keys are all Foreign Keys	Provides a list of entities in all the models that have foreign keys as their primary keys.
Entities without Definitions	Provides a list of all entities that have no definition text for the specified model.
Entities without Primary Keys	Provides a list of all entities that have no primary key for the specified model.
Many to Many Relationships	Provides the details of many-to-many relationships available in all the models in the Mart.
Model Attributes without Definition	Provides a list of all attributes that have no definition for the specified model.
Unattached Entities	Provides a list of entities that are not the parent of a relationship. The report includes information for all the models in Mart.

Diagram Reports

The following table describes the reports that can be run against diagrams:

Report Name	Description
Definitions	Provides the definition information of the specified diagram.
Domains	Provides the domain usage of the specified diagram.
Entities	Provides the entity information for the specified diagram.
Entity Attributes	Provides the details of all the entities and their attributes in the selected model.
Entity PK FK	Provides the details of primary and foreign keys for all the entities in the selected model.
Entity Subtypes	Provides the details of all the entity subtypes for the selected model.
Entity Supertypes	Provides the details of all the entity supertypes for the selected model.
Entity Table Attribute Column Datatype Nulls	Provides a list of all data type null values for entity attributes and table columns for the selected model.
Model Subject Areas	Provides a list of the Subject Areas and their members for the selected model.
Index Members	Provides a list of the index member usage for the specified diagram.
Index Properties	Provides the index properties for all objects in use for the specified diagram.
Relationships	Provides a list of relationship usage for the specified diagram.

Model Locks Report

Provides information about the lock status of all models in the selected library.

View and manage report results in the erwin Reports Viewer. Use the predefined reports available on the Tools menu, use either the Bulk Editor to view and edit object properties in the current model and export results to a CSV file, or use the Query Tool to execute predefined or customized SQL SELECT statements against a model.

Model Contents by Class

The Model Contents by Class report includes erwin objects available in the selected model based on their class.

Bulk Editor

The Bulk Editor provides the selection, validation, and maintenance of model object metadata, permits reusable customization (option sets), and realtime access to model changes. Export results or selected rows to a CSV file. You can use the Bulk Editor to edit a small set of properties over a large number of objects. Changes and updates are immediately committed as you make them, field by field.

Query Tool

The Query Tool is used to query the repository through executing SQL SELECT statements against a local model or a model in the mart. You can use the Query Tool to create your own .QRY report file. Save your option set locally to the model or as an XML file. Export your results to a CSV file. You can execute a query against the objects and properties in the model, the metadata defining those objects and properties, and the action log that records the changes that are made to your model during the modeling session. You can create new queries or paste text from another source (such as a .SQL file) into a query. Although the Query Tool provides a built-in query interface in erwin® Data Modeler, you can also use any third-party reporting tool that has ODBC capability to query erwin® Data Modeler modeling data.