Welcome › New Features and Enhancements in CA ERwin Mart Server

New Features and Enhancements in CA ERwin Mart Server

The following new features and enhancements are implemented in the current release of the CA ERwin Mart Server:

• Mart-Level reports in the Report Designer
• Pinned Reports from the Report Designer menu
• Cross-Model Reports
• Enhanced Database Support
• Mart Model Reporting Status
• Initialize the Mart with a Windows-authenticated User
• Schedule Mart Report Synchronization
• Use Multiple Threads to Update Mart Models for Reporting
• Mart Report Data Compression
• Use Multiple Threads to Load Models

Mart-Level Reports in Report Designer

You can now generate reports on the Mart. The reports that you generate could be administrative or about the model objects. For example, you can generate a report on the profiles that are attached to users, or on the list of entities without primary keys. When you generate the report, you can use the filter to search within specific objects. The filter supports SQL wildcard characters such as ? and %.

Note: You must have the Reports: View permission to create Mart reports.

Follow these steps:

1. Open CA ERwin Data Modeler and log in to the Mart.
2. Click Tools, Report Designer.
3. Enter a name for the report and click Mart.
4. Select the report subject in the Select Report Subject pane.
5. [Optional] In the Select Report Fields pane, select Specify Attribute Name at Run Time or Specify Model Name at Run Time check box.
6. Select the properties that you want to include in the report and click one of the following buttons:
   1. Click Run Report.

      If you have selected an option under Filter By, the Mart Report Filter dialog opens.

      Select the specific models that you want to get the results from. Enter the specific model object name. Use wildcard characters, if required.

      The report is generated and displayed. If you do not specify any model or entity the generated report includes all the models. If you have used a wildcard, by default, wildcard is applied to all the names. For example, if you type ID, the report includes Cust_ID and ID_For_Category.

   2. To add the report to the current Report Solution, click OK.

Pinned Reports from the Report Designer Menu

You can now open the built-in reports from the Open pinned reports from disk toolbar item. The pinned reports are available in the local computer of the user. These reports are segregated into categories and each category of reports is available in a separate folder. You can create a folder of your own add the reports of your choice to it.

The following folder includes the built-in reports:

Windows XP

C:\Documents and Settings\All users\Application Data\CA\ERwin Data Modeler\9.6\Configuration\Report Solutions\

Windows 7

C:\Users\<user name>\AppData\Local\CA\ERwin Data Modeler\9.6\Report Solutions

Reports that are copied directly under this folder do not appear in the Pinned Reports dialog. The reports must be in a subfolder under this folder.

Follow these steps:

1. Launch ERwin Report Designer and click Open pinned reports from disk on the toolbar.

   The Pinned Reports dialog appears.

2. Select the category of the report that you want to see.
3. Select one or more reports that you want to run and click OK.

   The report is included to the current Report Solution and the Pinned Reports dialog closes.

Cross-Model Reports

You can now generate a report on the properties of attributes and columns present across multiple models in a Mart. When you generate the report, you can use the filter to search within specific models. The filter supports SQL wildcard characters such as ? and %.

Follow these steps:

1. Open CA ERwin Data Modeler and log in to the Mart.
2. Click Tools, Report Designer.
3. Enter a name for the report and click Mart.
4. Click Attribute/Column in the Select Report Subject pane.
5. In the Select Report Fields pane, select Specify Attribute Name at Run Time or Specify Model Name at Run Time check box.
6. Select the properties that you want to include in the report.
7. Click Run Report.
8. Select the specific models that you want to get the attributes from. Enter the attribute or column name.

   By default, wildcard is applied to all the names. For example, if you type ID, the report includes Cust_ID and ID_For_Category.

9. Click OK.

   The report is generated and displayed.

Enhanced Database Support

You can now use a SAP Adaptive Server Enterprise 16 database for the Mart database.