Please enable JS

Build Heat Maps

July 10, 2019

Prolaborate provides a powerful yet intuitive tool to build Heat Maps 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 of business process or applications:

For example, here we see Projects and the Applications used in them.

Processes or applications grouped based on a property:

For example, Applications grouped by Business Unit:

End to End Relationships:

For example, here we have created a heat map to see how the following are interconnected – Roles, processes, applications, business activities, and requirements.

In the screenshot below, we can see the applications when clicked on “CFO” role > “Program 1” project.

We can further drill down to see the 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.

Build using Chart Designer

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 Heat Map and click on Designer.

Follow these steps to create a heatmap:

  1. Choose the packages that contain the data for your chart i.e., the packages that has the EA objects which should be considered for the chart.
  2. To filter the selection, specify the Type or Stereotype. Enable Fully Qualified Name to see full qualified names
  3. If you want to further filter the selection, specify a unique property or tagged value.
  4. Choose the information you want to show in Level 1 i.e., when any user opens the dashboard
  5. You can also group this Level 1 selection if needed

Repeat the following steps to add more levels to the Heatmap:

  1. Choose the relationship (Connector Type or Stereotype) between the elements you have chosen at the first level with those you want to choose at the second level
  2. To filter the selection, specify the Type or Stereotype. Enable Fully Qualified Name to see full qualified names
  3. If you want to further filter the selection, specify a unique property or tagged value
  4. Choose the information you want to show in Level 2 i.e., when any user opens the dashboard

Sample Configuration and Result:

Configuration – Level 1:

Result – Level 1:

Configuration – Level 2:

Result – Level 2:

Configuration – Level 3:

Result – Level 3:

Configuration – Level 4:

Result – Level 4:

Configuration – Level 5:

Result – Level 5:

Build using SQL Queries

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:

Click anywhere to see further details.

Chart Query - 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:

Chart Query - 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:

Chart Query - 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:

Customization Options

Heat map has following settings:

  1. General

    • Legend– Disable to hide the legend.
    • Tooltips – Disable to hide the information that is shown on hover
    • Color Range – Pick the color range that needs to be used while displaying the chart
  2. Heatmap Settings

    1. Childer Names –Disable to hide the names of children of a level
    2. Navigation –Disable to hide the breadcrumb navigation
Any questions? Contact us