Prolaborate lets you create dynamic reports quickly from your EA model data.
In this guide, we will look at how you can build live 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.
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:
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.
For example, enable Select All Levels and click on Enterprise Architecture Model to select everything under it.
The following filters are available:
The types available are:
You can either enter the base type or choose from the dropdown
You can either enter the stereotype name or choose from the dropdown.
List of all diagrams in the Model
List of all Elements with Archimate_ApplicationService as Stereotype. (Table Columns will be shown as per the configuration in Form Designer. Read about Form Designer in this link)
You can change the filter type to SQL queries to enter 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 “Subreport” field.
You can give a name to the Subreport column to make it self-explanatory to your users.
All the columns you will 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, you need to define the Report query as follows:
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:
select name,ea_guid as classguid from t_object
select name, object_type as basetype, stereotype as stereotype from t_object
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
1. Applications List by LifecycleReport 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 Dashboards
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>'
2. Application Health Check
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
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>'
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
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.