Prolaborate provides a powerful yet intuitive tool to build Bar charts based on Enterprise Architecture data in minutes.
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 Bar and click on Designer.
Follow these steps to create a bar chart:
Sample Configuration and Result
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.
Bar chart will be created based on the properties you define as “Series” and “GroupName”.
select object_type as series, stereotype as groupname from t_object
Optionally, you can use the alias “ChartValue” if you want to display an integer value field instead of counts on bars.
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 Query and Result
select tv1.Value as Series, tv2.Value as GroupName
from ((t_object o
left join t_objectproperties tv1 on tv1.Object_ID = o.Object_ID)
left join t_objectproperties tv2 on tv2.Object_ID = o.Object_ID)
where tv1.Property='Security Classification'
and tv2.Property ='Lifecycle'
Chart Shown in Dashboard
select o.Name as Name, otv1.Value as SecurityClassification, otv2.Value as Lifecycle, o.ea_guid as Classguid, o.Object_Type as BaseType, o.Stereotype as Stereotype from (( t_object o left join t_objectproperties otv1 on otv1.Object_ID = o.Object_ID) left join t_objectproperties otv2 on otv2.Object_ID = o.Object_ID) where otv1.Property = 'Security Classification'And otv2.Property = 'Lifecycle' and otv1.Value = '<series>'
Report shown when clicked on chart
The following settings are available: