Creating Charts in Enterprise Architect to Aid Decision Making
Webinar September 2014
Charts in Enterprise Architect can help you manage projects, communicate strategy, identify trends, track KPI's and make informed decisions.Mr Scott Hebbard, Communications Manager at Sparx Systems, demonstrates how to:
- Place Charts and Graphs on diagrams, group them to display an interactive project dashboard and include them in generated reports
- Source data from the model, from specific Packages within the model, or from a custom SQL query that extracts the information from the model
- Create burn down charts and time series graphs that are automatically updated by Enterprise Architect on a regular basis.
Explore the Example Dashboard and Charts Model
We have provided the example Enterprise Architect model used in the webinar.
|Example model: dashboard.eap|
Questions from the AudienceClick on a question to see the answer.
Which Enterprise Architect version supports the Charts and Dashboard feature?
Charts and Dashboards were introduced with Enterprise Architect 11.
To download a 30 Day Free Trial of the latest version of Enterprise Architect, please visit:
Is this capability part of the standard Enterprise Architect product or is it a Project Management add on?
It is part of Enterprise Architect at no additional cost. The Charts and Dashboard feature is included with all editions of Enterprise Architect.
I recently bought version 10 in May 2014, can I download Enterprise Architect Version 11.x without repaying license fees?
Yes. Purchasing a license makes you a registered user for 12 months, which entitles you to download updates and new builds free for a period of 12 months.
Charts and Dashboards
What other types of charts are available?
Enterprise Architect can create a number of different charts including:
- Pie - 2D and 3D
- Doughnut - 2D and 3D
- Line Graph (Time Series)
- Table (Model Views)
- Horizontal bar - 2D and 3D
- Vertical column - 2D and 3D
Will it be possible to present these Charts online as part of an HTML export or report?
Yes. To generate a HTML report,right-click the package containing the chart you want to publish online and select the Documentation | HTML Report context menu option.
This will allow you to automatically generate a web page that contains your completed Chart.
For more information, view this video on HTML Report Generation using Enterprise Architect.
How do you gain access to the Dashboard Diagram?
On the New Diagram dialog, in the Select From panel click on Extended, and in the Diagram Types panel click on Dashboard. You will only be able to see Dashboard if you have Enterprise Architect version 11 or above.
If you want to use a chart on another type of diagram, select the Dashboard Toolbox shown in Figure 1.
Figure 1: Selecting the Dashboard Toolbox to access Chart Elements.
Where can I learn about the object model for writing my own custom SQL code?
The Enterprise Architect User Guide provides a comprehensive description of the Object Model. Review the object type descriptions and the table name for each type, under the following link (e.g. see Element Class to show t_Object).
Can we get a copy of the project that was used for the demo?
The EAP file is available for download here.
Please enter the Model Credentials listed below.
Is it possible to refresh charts automatically e.g. once per day?
Yes. Time Series Charts can be automatically updated by the Cloud Server according to a schedule that you define in the element Properties. The Time Series Chart element Properties can be set to record a result manually, daily, weekly or monthly.
Other chart images are dynamically generated, showing the selected properties of the model elements at the moment:
- The definition is saved, or
- The element's parent diagram is opened, or
- You right-click on the element in the open diagram and select the Refresh Chart or the Refresh List menu option
Can Charts display information about Use Cases and other model Elements?
Yes, Use Cases and other element types can be counted and included in Charts. For example, the video presentation shows a Chart in which all Classes in the model are counted, and that sum is then displayed via a chart.
Where can I find additional demos or examples to learn more about the Dashboard feature?
Examples can be found under the Reporting | Charts section of the Enterprise Architect User Guide.
Also read the Enterprise Architect User Guide for more information on the Enterprise Architect Object Model.
Can we create dashboards from non-SQL data source?
Yes, you can create a dashboard based on the contents of a package and CSV data. Both techniques were shown during the webinar.
At the 2 minute and 30 seconds mark, the video shows how to generate a graph based on package contents. While at the 9 minutes and 30 seconds mark, the webinar demonstrates how to graph CSV data.
Does Enterprise Architect allow you to extract the data in, say, a CSV format for further statistical analysis such as regression analysis?
The Chart Data is contained within a Tagged Value labelled
ChartProperties. An example Tagged Value is shown below in Figure 2. You can copy the text from the Tagged Value and use it to conduct further statistical analysis such as regression analysis in a third party tool. The Tagged Value is stored as XML, rather than CSV.
Figure 2: The
ChartProperties Tagged Value and corresponding output.
Can you change what is displayed in the output?
Yes. Using the Appearance tab you can change a Charts appearance and alter what information is displayed, which includes:
- selecting a diagram category
- use of a legend/key
- colour intensity
- the position of labels
Can you prevent some users from editing a dashboard?
Yes. You can lock a diagram and prevent users from editing a dashboard. Please read the Enterprise Architect User Guide for more information on locking a package, element or diagram.
Can Charts be used with a Tagged Value?
Yes, you can count the number of times a given Tagged Value occurs in your Model using a SQL Query.
Figure 3 below charts a Tag named IssueStatus and displays the count of each IssueStatus value in the model.
Here is the SQL query:
SELECT IssueStatus.Value AS Series, 'January 2014' AS GroupName
FROM t_object, t_objectproperties IssueStatus
AND MONTH(t_object.CreatedDate) = 1 AND YEAR(t_object.CreatedDate) = 2014
AND t_object.Object_ID = IssueStatus.Object_ID
AND IssueStatus.Property = 'IssueStatus'
Figure 3: A Chart of Tagged Values