The Analyst BI Designer

Content

Introduction

Analyst BI is a DbSchema tool featuring different type of charts and customizable database reports. The sheets can interact one with another.

Sample Project

In the next slides you will see examples created using DbSchema sample project, available in the first DbSchema screen.
DbSchema Sample Project

Wizard

The Analyst BI can be started from the Tools menu or by right-clicking any table header. Here I used the 'country' table from the sample project.
Analyst BI Wizard

Analyst BI Designer

This will open the Analyst BI designer, with a chart component. The chart needs to be configured and is not yet visible. Click the red cell in the designer to configure the chart.

Configure chart in the Analyst BI Designer

Configure Chart Axis

The chart require the two axis variables to be configured. We can drag the name and population variables to the axis values.
Configure chart axis

Last Changes

Here I changed the chart type to 'Pie' and I edited the data source script to order the countries by population, with a limit of 20 countries. Press 'Apply' and you should see the chart below.

Configure chart axis

The data source looks like this:

Chart data source

View Chart in System Browser

From the menu you can choose to view the chart in the system browser. Also you can press the 'Design' button to leave the design mode.
View chart in the system browser.

Insert Columns or Rows and Merge Cells

Right-click the chart cell and from the menu you can add other rows or columns. You can select multiple cells and from the menu you can merge the cells.

Add column or row

Create New Components

Empty cells are marked with a solid line. Click one of them and the Component Palette will show on the right. Here you can choose new components to be created: charts, labels (text), buttons, text fields, combo boxes, radio buttons, etc.
Create new component.

Create a Report

Similar with a chart, you can create reports. This report was created using the wizard for the table 'offices'.

Analyst BI report.

The Designer Structure

The designer contains a main panel, here called 'Panel'. This contains cells. Inside any of the cells we can place other panels or tables, with their own cells, etc. Like this we can build a hierarchy of tables and panels. Different panels and tables are using different colors (green, blue, etc.).

Analyst BI Panel Hierarchy.

Our report contains a panel and a table. The table is placed in one of the panel cells. This cell was merged on the right with the other cells from the same row. The empty cells are marked with a solid line, and cells having a component with a dotted line.

Analyst BI Report.

Table Properties

Clicking the table blue label 'Table' we can edit the table properties, including the data source query.
Edit table properties.

Master-Detail Reports

Using the panel-table-table imbrication we can create master-detail reports. In the image below we list offices, and for each office we list the employees.

Master-Detail database report.

As we can see there are two tables imbricated one in another.

Master-Detail database report.

The first table data source query is:

SELECT * FROM "PUBLIC".offices

And the second table data source query is:

select * from employees where `officeCode`='${officeCode}'
The queries are parsed using Groovy templates, where the ${...} and <%....%> are considered Java expressions. This expressions are receiving the data from the parent containers (tables, panels) data source queries as variables. officeCode variable is generated by the first table data source query, and is used in the WHERE clause of the child table data source query. Notice the quotes: '${officeCode}', as this is a string in the query.

Interaction Between Sheets

Using buttons a sheet may access another sheet.
Sheet interaction using buttons.
The button properties will let you configure the sheet to open when the button is pressed as well the variables to pass over to the target sheet.
Button properties.

Sheet Properties

Sheets can be configured to open as dialogs. The have also an initialization script which you can use, for example, to modify data in the database. The input variables are used to make sure some variables are received from the caller sheet. You can configure an exception to be thrown if a variable is missing.
Sheet properties.

Deploy Tomcat WAR

The Analyst BI sheets can be deployed as Tomcat WAR applications and can run independently. You can export the created application under any tomcat instance.