JBoss Dashbuilder - Quick Start Guide

Dashbuilder is a full featured web application which allows non-technical users to visually create business dashboards. Dashboard data can be extracted from heterogeneous sources of information such as JDBC databases or regular text files.

Some ready-to-use sample dashboards are provided for demo and learning purposes.

If you want to build the project and execute a quick demo, please, proceed as indicated:

The purpose of this chapter is NOT to provide a full detailed explanation of the tooling, but to guide you through the key steps to get your first dashboards created. The following section will provide basic information about how to configure the system to retrieve information from existing databases or files, create new indicators and manage different dashboards.

For this guide, it's assumed the simple installation has been done, with the standard set of examples and user and role configuration. It's important to notice this configuration MUST NOT be used in production, since it provides default security credentials.

The procedure to create a brand new dashboard is pretty simple as we will see in the following sections. That procedure is composed of 3 main stages:

3.1. Creating a data provider

The first thing to do, after you have accessed the web application, is to create a data provider. On the left menu, go to 'Administration > Data providers' and once there, select the option 'Create new data provider'.

The purpose of data providers is to gather information from any system, either a database, a file or any other, and transform it to the internal in-memory representation for building dashboards. As you may guess there exists different data sources and therefore different ways to retrieve as we're going to see next.

3.1.1. Retrieving data from a CSV file

Click on 'Create new data provider'. The following fields will be shown in the form, with some sensible defaults:

• Type: in this case - choose the CSV File

• Name: Write the name you want to give to our data provider (this field is multi-language).

• CSV file URL: Here write the URL where oyur CSV file is located.

  As an example you can grab the CSV file used by the Sales Dashboard, just copy & paste the following URL:

  https://raw.github.com/droolsjbpm/dashboard-builder/master/modules/dashboard-samples/src/main/webapp/WEB-INF/etc/appdata/initialData/expenseReports.csv

• Data separator: Left as is.

• Quoting symbol: Left as is.

• Date format: Where we can define different date formats or even hour.

• Number format: Where we can define the number format.

Once you have filled all the fields, click on 'Try', to check that everything works properly. The application will give you a message 'Correct data set ...' and we continue by pressing 'Save'.

Next, a screen is shown with all the fields found after parsing the file, giving us the option to change the name of each field. For numeric fields it gives us the option to specify if we want numeric values to be treated as labels by the dashboard engine. This is something really useful when dealing with numbers which actually behave as labels, f.i: the numeric reference code of a product item.

After this last step, you can save and finish the creation of your new data provider.

3.1.2. Reading data from an SQL query

You can create a data provider to query a relational database. Go to Administration > Data providersand click on 'Create new data provider'. Choose the 'SQL Query' option and fill the form with the data provider name and the SQL query that will retrieve the data.

In this form you have the ability to select the data source where the data comes from. By default the local data source is selected but you can define new connections to external data sources. To do this you should go to the 'Administration > External connections' section and from there you can create a new data source connection.

Let's get back to the creation of our SQL data provider. Once the data source has been selected and the query is typed in, you can click on the 'Try' button, and if the query is successful you will get the following message.

After that, you can rename the name of the properties to provide a more user friendly name.

Finally, just click the 'Save' button to confirm the creation of the data provider:

3.2. Creating a KPI

Once the necessary data providers have been created, you can continue by adding a new Key Performance Indicator to an existing page. All dashboards are created by adding indicators and other types of panels to pages. A dashboard is a page with a mixture of different kind of panels placed into it. The following screenshot shows an example of a Sales Dashboard:

Pages can be created from scratch, or duplicating an existing one. Both options are explained in the following sections. Meanwhile we will assume the page already exists and we only want to add an indicator.

Indicators are a special type of panels, which are the widgets that can be placed within the page. To add a panel or indicator just click on the toolbar icon 'Add panel to the current page':

This will make a popup be shown with all the available panels:

To add a new 'Key Performance Indicator', click onDashboard > Key Perfomance Indicator. Drag the 'Create panel' option and drop it into any of the page regions. You will see that they are being highlighted while you move the mouse over them, then simply drop the panel.

Once dropped, the first step is to select the Data Provider you need to use, as configured before, to feed the charts and reports with data. Select any of the data providers and then you can start creating a new indicator.

Now, you must see the chart edition panel. It's an intuitive environment which helps you configure different type of charts and reports...

• Domain (X Axis): The data column that is taken as the X axis. In this example, we choose the property 'Country'.

• Range (Y Axis): Information to be grouped and aggregated for every domain interval. For example: 'Amount'.

• Renderer: The rendering library to use. Each one provides different features and visualization style. By default 'NVD3'.

• Sort intervals by: It's how the domain values can be sorted, for example, according to its range value.

• Sort order: It can be ascending or descending.

To finish the panel edition just close the panel edition window. If you want to get back again, just click on the right upper corner of the panel area and select the 'Edit content' menu option.

The system provides you with 3 types of chart displayers: bar, pie and line, and a special table displayer very useful to create tabular reports. The system also comes with 2 rendering engines: NVD3 (pure HTML5/SVG technology) and a Flash based one, Open Flash Chart 2. Each renderer has its own available features, so depending on the type of chart and renderer choosen you can end up with some display features enabled or disabled depending the case. For instance, the 'Paint area' feature is not available for OFC2 line charts.

3.3. Building a dashboard

A dashboard is basically a page with some KPIs placed on it (plus some other additional widgets as we will see later on). There are two different ways of creating a page:

Starting as a blank page:

Duplicating an existing page:

You will find these icons at the top of the page, in the administration bar:

To create a new page, click on the 'Create new page' icon:

A form will be shown to fill in some parameters:

• Page title.

• Parent page: Pages are organized in a hierarchical way. This is the parent page.

• Skin: This will select and specific look'n'feel and CSS stylesheet for this page. You can leave the default value.

• Envelope: Defines which kind of HTML template will be placed around the page layout.

• Region layout: This is the template, that is, how regions are organized to place the panels inside the page. We can choose any of the installed types, for example, "Demo - Default template with sliding".

Most of these properties will be discussed in the chapter about 'Customing look'n'feel'. After creating the page, you might realize the page is still not accessible from the left menu but you can see it in the combo list in the administration toolbar:

If you want this page to be shown in the left menu, you can click on 'Edit content' and then add the newly created page to the list of options displayed in the menu.

Repeat until the page has all the content and panels required. After dropping the panels into the right regions and configuring them, you might be able to create dashboards that look like the following one:

As you can see, a dashboard is usually composed by one or more instances of the following panel types:

• Dashboard > Key Performance Indicator

• Dashboard > Filter & Drill-down

• Navigation > Tree menu

• Navigation > Language menu

• Navigation > Logout panel

3.3.1. Duplicating a page

As mentioned earlier, another way to create new pages is to copy an existing one. We can do that via the 'Duplicate current page' icon which is a much faster way to create pages. After clicking on the clone icon located at the toolbar, a page similar to the image below will be shown. From there we can select those instances we want to duplicate and those we want to keep as is (to reuse).

Once finished, press the 'Duplicate page' button and a brand new page will be created with the same name as the original one but starting with the prefix 'Copy of'. Notice that if a panel instance is reused then any changes made to it will be reflected on all the pages where such instance is being used. this is a cool feature when we are defining for instance our navigation menus since we can define a single'Tree menu'panel and then configure all the pages to display the same menu instance.

3.3.2. Configuring filter and drill-down

The 'Filter & Drill-down' panel allows for the quick definition of dynamic forms that will allow us to navigate troughout the data displayed by the dashboard. Once an instance of the 'Filter & Drill-down' panel is dropped on the oage we just have to select the 'Edit content' option from the panel menu. After that, a popup window similar to the following will be displayed:

This is a filter configuration panel where we can set the filter behaviour. Let's focus first on the middle bottom part of the screen: the Data provider's property table, which lists the properties of ALL the data providers referred by the KPIs on the page. For example, if we are building a sales dashboard and all its KPIs are built on top of the same data provider called 'Sales dasboard demo' then the system lists all the data properties of the 'Sales dashboard demo ' provider. Hence, only the properties we select as 'Visible' will be part of the filter form. Aditionally, we can enable the drill-down feature for each property. If enabled then the system will redirect to the target page when the property is selected on the filter form. Below is an screenshot of the filter panel of the 'Sales dashboard demo'.

As you can see the form is composed by all the visible properties selected. For each property the system reads its configuration by asking the underlying data provider. For label type properties a drop-down list is displayed, containing as options all the disctinct values of the data provider's column. When the user submits a change on the filter form then the following operations are carried out by the dashboard visualization engine:

1. It reads the data sets for the target data providers. A data provider is in the target set if it contains the selected filter property.

2. It applies a filtering algorithm in memory on the target data.

3. If drill-down is enabled for the selected property then the target page is set as current and the steps #1 and #2 are repeated again.

4. Finally, after filtering, all the sensible KPIs are updated in order to display the filtered data. By sensible, we mean a KPI which is displaying data that is being filtered.

When we talk about security we refer to the ability to define authorization policies in order to grant or deny users access to a given resource. Therefore, we first have to define who are the target users and what are the resources we want to protect. As resources we have the following:

As of users, the application doesn't own a user repository. Users are managed outside the application. This means the login itself is delegated to the application server. After login, the application server pass to the application both the id of the user and the roles he/she has. The full list of available roles are defined into the application's WEB-INF/web.xml file.

Let's see next how to define custom authorization policies to grant/deny access to a workspaces, pages or panels instances per role.

4.1. Workspace permissions

Below is a screenshot of the permission management screen for a given workspace:

The list of allowed actions are:

• Access: login into the application.

• Administrate: access to the toolbar and hence to the whole system configuration features.

• Create pages

• Edit: change the workspace properties.

• Clear: ability to delete the workspace.

• Edit permissions: ability to grant/deny permissions.

• Change allowed panels: restrict the type of panels that can be used in this workspace.

To assign a permission you must select the target role and the list of actions allowed over the selected resource.

• Target roles (who): What user will be granted/denied with the permissions defined.

• Allowed actions: depending on the type of the resource we can enable/disable what the user can do on this resource.

• Reverse (optional): very useful when we have a set of roles and we want to grant/deny a permission to all the roles but one.

The above description is the common way to specify a permission regardless of its type. It applies to the definition of permissions for workspaces, pages and panels.

As you can see in the previous figure, the system grants by default the full set of permissions to the role 'admin'. That way it becomes very easy to create a user that can do everything as long as the role admin is assigned.

4.2. Section permissions

Below is a screenshot of the permission management screen for a given page:

The list of allowed actions are:

• Visualize: make the page visible.

• Edit: change the page properties.

• Clear: Ability to delete the page.

• Edit permissions: ability to grant/deny permissions for this page.

4.3. Panel permissions

Below is a screenshot of the permission management screen for a given panel:

The list of allowed actions are:

• Visualize: make the panel visible.

• Edit: change the panel properties.

• Edit permissions: ability to grant/deny permissions for this panel.

4.4. Role home page

The home page is the page the user will be redirected after initializing its session. In order to get the appropriate home page for the user the security subsystem carries out the following tasks:

1. Just after login the security subsystem get the roles of the users and evaluates what workspaces the user is allowed to enter ('Access' action granted)

2. Once the list of workspace is calculated then the system selects the workspace identified as default (see workspace properties), if any then get the first in the list.

3. The home page settings are read for the target role and workspace. The system evaluates if the specified home page is visible for the user ('View' action granted). If not then the system takes the first visible page from the full list of pages in the workspace. The following screenshot shows the home page configuration screen.

To wrap up, it's worth to mention that thanks to the permission system we can build a workspace structure with several pages, menus and panels and start defining what pages and panels within a page will be visible for each role. We can also define special kind of users and give them restricted access to certain tooling features or even restricted access to a page subset. The chances here are infinite.

There exist three types of graphic resources.

You can handle all these components from the administration console, under the node 'Graphic resources' and create/modify them in order to fully customize the look and feel of your dashboards.

Each graphic resource is packaged in a file. Zip file which content varies depending on the type of component. Nonetheless, the structure of the management screen is the same regardless of the type of the resource being handled. As we can see on the screen, the upload form is composed by two fields:

Each zip comes with a definition file which name varies depending on the type:envelope.properties, skin.properties or layout.properties. This property file have two distinct parts:

            # Name
            name.en=Default skin
            name.es=Skin por defecto

            # CSS
            resource.CSS=styles/default.css

            # Icons
            resource.BULLET=images/bullet.gif
            resource.CLOSE=images/close.gif
            resource.DOWN=images/down.gif
            resource.EDIT_MODE=images/edit_mode.gif
            resource.HEADER_BG=images/header_bg.gif
            resource.HEADER_LEFT=images/header_left.gif
            resource.HEADER_RIGHT=images/header_right.gif
            resource.ICO_HELP=images/ayuda.gif
            resource.LEFT=images/left.gif
            resource.MAXIMIZE=images/maximice.gif
            resource.MINIMIZE=images/minimice.gif
            resource.PROPERTIES=images/properties.gif
            resource.REFRESH=images/refresh.gif
            resource.RESOURCES_MODE=images/resources_mode.gif
            resource.RESTORE=images/restore.gif
            resource.RIGHT=images/right.gif
            resource.SHOW=images/show.gif
            resource.UP=images/up.gif