Prolaborate provides a powerful yet intuitive tool to build Architecture Landscapes based on Enterprise Architecture data in minutes.
With these powerful visualizations, you can present any kind of architectural views in a single page. Here is what you can do:
Quick Overview
For example, here we get a quick overview how L0, L1, and L2 business capabilities are inter-connected.
Highlight Metadata to enable decision making:
For example, we have color-coded the applications here based on their lifecycle stage.
End to End Relationships:
For example, here we see how the following are interconnected – Roles, processes, applications, business activities, and requirements.
Note we will be looking only at the capabilities of chart widgets in this guide-; please refer to Dashboard Designer to learn about the general functionalities of the dashboard.
To create a Chart, click on Menu > Dashboards. Click on Add New to create a new dashboard or edit icon to edit a dashboard.
Click on Add Widget or Add icon on the bottom right to see the list of widgets. Click on EA Chart and then on Add New Widget.
Select Landscape and click on Designer.
Follow these steps to create the chart:
Repeat the following steps to add more levels/groups:
When you are building advanced charts using SQL queries, Chart query is used to build the charts and Result query is used to show in-depth information on click.
This chart will be created based on the property you define using the Series alias. Optionally you can group them using groupname alias.
As this is a multi-level chart, you can have many levels of Chart query and result query. You can click on List View to see the table view similar to the ones shown in above samples.
And to link one level to the another, you need to use the following syntax:
level[number].[alias of the property used in it] = level[number].[alias of the property using in it]
For example,
level2.ObjectID = level1.startelementid
To enable users to see in-depth information on click of a section of the chart, Aliases in Chart query need to be used in Result Query.
For example, if chart query is
select object_type as series from t_object
the respective result query will be
select name, object_type, stereotype where object_type = ‘<series>’
Additionally, you can use the following aliases in Result query:
a. Add alias “classguid” to the GUID - to see details of an item on click, For example:
select name,ea_guid as classguid from t_object where object_type = ‘<series>’
b. Add aliases - Base Type and Stereotype to Type and Stereotype respectivelyto see appropriate EA icons, For example:
select name, object_type as basetype, stereotype as stereotype from t_object where object_type = ‘<series>’ and stereotype= ‘<groupname>’
c. Prefix an alias with “hide_” to not see a column even when used in the query. 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 where object_type = ‘<series>’ and stereotype= ‘<groupname>’
Sample Queries and Results
Chart Query - Level 1:
select target.Object_ID as startelementid, source.Name as GroupName, target.Name as Series
from ((t_object source
left join t_connector con on con.Start_Object_ID = source.Object_ID)
join t_object target on target.Object_ID = con.End_Object_ID)
where
source.Stereotype='ArchiMate_BusinessActor'
and target.Stereotype='ArchiMate_WorkPackage'
Chart Shown in Dashboard
Add Level 2:
select target.Object_ID as startelementid, source.Name as GroupName, op.Value as
Series, source.Object_ID as ObjectID from (((t_object source left join t_connector
con on con.Start_Object_ID = source.Object_ID) join t_object target on
target.Object_ID = con.End_Object_ID) left join t_objectproperties op on
op.Object_ID=target.Object_ID) where source.Stereotype='ArchiMate_WorkPackage' and
target.Stereotype='ArchiMate_ApplicationComponent' and op.Property = 'Health Indicator'
Condition to link to Previous Level:
level2.ObjectID = level1.startelementid
Chart Shown in Dashboard
Add Level 3:
select source.Object_ID as startelementid, source.Name as Series, op.Value as
GroupName from (t_object source join t_objectproperties op on
op.Object_ID=source.Object_ID) where op.Property = 'Health Indicator'
Condition to link to Previous Level:
level3.GroupName = level2.series
Chart Shown in Dashboard
Add Level 4:
select source.Name as GroupName, target.Name as Series, source.Object_ID as ObjectID
from ((t_object source
left join t_connector con on con.Start_Object_ID = source.Object_ID)
join t_object target on target.Object_ID = con.End_Object_ID)
where
target.Stereotype='Activity'
Condition to link to Previous Level:
level4.ObjectID=level3.startelementid
Chart Shown in Dashboard
The following settings are available: