Please enable JS

Build Enterprise Architect Reports

June 28, 2019

Prolaborate lets you create dynamic reports quickly from your EA model data.

In this guide, we will look at how you can build dynamic reports.

Note that we will be looking at only the capabilities of report widgets in this guide; please refer to Dashboard Designer to learn about the general functionalities of the dashboard.

Create Reports using Designer

You can create a report from through Report Designer or SQL Queries. In this section we will look at how you can create a report using Report Designer.

Click on Menu > Dashboards.

Click on Add New to add a dashboard or click on Edit icon on an existing dashboard.

Click on Add Widget, select EA Report widget from the list of widgets and click on Add New Widget.

Creating a report involves two steps:

  1. First you need to select the packages from which you want to generate the report from.
  2. Then you can apply the filters. You can filter by Type, basetype and stereotype.

Step 1

Enable Select One Level toggle if you want to select a package and its contents up to one level.

Enable Select All Levels toggle if you want to select all the items under it (including sub packages and elements in it) when you select a package.

Step 2

The following filters are available:

  1. Type

    The types available are:

    • All
    • Diagrams
    • Packages
    • Elements
    • Linked Documents
  2. Base Type

    You can either enter the base type or choose from the dropdown

  3. Stereotype

    Enable Show Configured Properties to show all the properties you have configured from the Form designer in Modeling Languages for the chosen stereotype. This will work only if you are giving only one Stereotype.

    To know more about Modeling Languages, please refer to its User Guide

Sample Reports created using Report Designer

  1. List of all diagrams in the Model

    Configuration

    Result

  2. List of All Elements with Stereotype Name as Activity (Table Columns as configured in Form Designer)

    Configuration

    Result

Create Advanced Reports using SQL Queries

You can change the filter type to Custom Query to enter SQL queries to create advanced reports.

If you want to see a subreport based on the data in your report, you can enter a query in “Enable Subreport” field.

You can give a name to the subreport column to make it self-explanatory to your users.

All the columns you would be using in your “where” part of sub report query must be in “select” part of report query.

For example, if you want to use object_type and stereotype in your “where” statement of subreport query, they must be part of your “select” statement in report query.

Sample report query:

select name, object_type as basetype, stereotype as sttype from t_object

Sample subreport query:

select name, status, priority from t_object where object_type = ‘<basetype>>’ and stereotype = ‘<sttype>’

You can use the following aliases if necessary:

  1. If you want links on the names of EA objects, add alias classguid to the GUID. For example: select name,ea_guid as classguid from t_object
  2. If you want to see appropriate EA Icons, add these aliases Base Type and Stereotype to Type and Stereotype respectively. For example: select name, object_type as basetype, stereotype as stereotype from t_object
  3. If you don’t want to see a column but you need to use it in your “Where” query or as an “alias” as mentioned above, use “hide_” prefix. For example, the following query will give the same result as above but Base Type and Stereotype columns will not be shown in the result: select name, object_type as hide_basetype, stereotype as hide_stereotype from t_object

Sample Reports created using SQL Queries

1. Applications List by Lifecycle

Report Query select o.Name as Name, o.ModifiedDate as Modified, otv.Value as Lifecycle, o.ea_guid as CLASSGUID, o.Object_Type as hide_BaseType, o.Stereotype as hide_Stereotype from ( t_object o left join t_objectproperties otv on otv.Object_ID = o.Object_ID) where otv.Property = 'Lifecycle'

Report in Dashboard

Subreport Query

select o.Name as Name, o.ModifiedDate as Modified, otv.Value as Lifecycle, o.ea_guid as CLASSGUID, o.Object_Type as hide_BaseType, o.Stereotype as hide_Stereotype from ( t_object o left join t_objectproperties otv on otv.Object_ID = o.Object_ID) where otv.Property = 'Lifecycle' and otv.value = '<Lifecycle>'

Complete Subreport

2. Application Health Check

Query

select o.Name as Name, tv1.Value as HealthIndicator, o.ea_guid as Classguid, o.Object_Type as hide_BaseType, o.Stereotype as hide_Stereotype from (t_object o left join t_objectproperties tv1 on tv1.Object_ID = o.Object_ID) where tv1.Property='Health Indicator'

Report in Dashboard

Subreport Query

select o.Name as Name, tv1.Value as HealthIndicator, o.ea_guid as Classguid, o.Object_Type as BaseType, o.Stereotype as Stereotype from (t_object o left join t_objectproperties tv1 on tv1.Object_ID = o.Object_ID) where tv1.Property='Health Indicator' and tv1.value = '<HealthIndicator>'

Complete Subreport

View Complete Report

Click on View All from Dashboard widget to see the full report.

You will be taken to the Table view.

From Table view, you can

  1. Show 10, 25, 50 or 100 entries at a time
  2. Search for any text
  3. Show/Hide columns from the table which you feel are not necessary
  4. Download the list in xlsx, csv and pdf formats
  5. View the list in full screen
  6. Search for text from any single column
  7. Click on the Name of an element to see its details
  8. Double click on the Name to go to its Overview page

You can switch to Thumb view to see diagram thumbnails in your results.. Click on View details to see their details.

You can also switch to List view to see description of EA objects as well in the primary view. Click on the Name to see its details.

Any questions? Contact us