Q.7. Publishing

In the previous sections we looked at setting up EDAB and creating reports and charts. This section deals with publishing reports, charts, and maps.

Q.7.1. Dashboards

You have to use dashboards to publish reports, charts, and maps in EDAB. You can place multiple items on the dashbord to make a single presentation page. You can also define common filters for the dashboard items and set-up drill-down for individual dashboard items.

Dashboards are created in the thin-client Dashboard Builder interface. To launch the Dashboard Builder, click the Dashboard Builder link in the EDAB start page. The interface will allow you to build a new dashboard.

Click to view larger image

Dashboard Builder Interface

Q.7.1.1. Create a Dashboard

In this section we will guide you through creating a dashboard from report, chart, and map templates that come with EDAB installation. At first we need to add some templates to the dashboard. To add reports, charts, or maps to the dashboard, click the Add Report/Chart/Map icon on the dashboard toolbar. After you have clicked the button, the Insert Reports/Charts/Maps dialog will appear. The dialog contains a tree that mirrors the folder structure in the Organizer. Next, expand the Examples node and then the QuickStart and QuickStart Dashboard sub-nodes, as shown on the image below.

Insert Reports/Charts/Maps Dialog

From the dialog, click on all the templates (Total Sales By Category chart, Sales By State map, and Products Sales report) in the QuickStart Dashboard node. This will insert the templates into the dashboard. Once you have inserted the templates, close the dialog by clicking OK button.

Now move the Sales By State map template by clicking to the map header and dragging it to the lower left position in the dashboard. Then select the Total Sales By Category chart and drag it to the upper right position in the dashboard. Finally, move Products Sales report and drag it below the chart. You can also resize the chart/report/map by clicking and dragging the sizing handle that appears in the lower right corner of the templates. After that, the dashboard should look like the following image:

Click to view larger image

Dashboard with Added Templates

Next, we will add dashboard shared parameters that allow us to group common parameters from the chart, report, and map into a single parameter. First, open the shared parameter dialog by clicking on the Shared Parameters icon on the toolbar. This will open the share parameters dialog that allows you to add shared parameters to the dashboard.

Share Parameters Dialog

From the dialog, click Add Share button. This will open another dialog that allows you to specify a shared parameter.

Click to view larger image

Shared Parameter Dialog

The left-hand side of the dialog shows all the available parameters from all the charts, reports, and maps in the dashboard. You can select which parameters you would like to add to the selected parameters list by selecting them in the left-hand side and clicking the Add button. Note that all parameters in the selected parameters list must have the same data type.

In this example, we will create two shared parameters (Start Date and End Date) and put them into a date range panel. We will start with the first parameter (Start Date). First, enter the parameter name Start Date to the Shared Parameter Name text box in the top dialog. Enter the same text to the Prompt Name text field and then select all the Start Date parameters from the list on the left (you can select the parameters by holding CTRL key and clicking on the appropriate items in the list). After you have selected all the Start Date parameters from the list, click the Add button. This will add the selected parameters to the list on the right. At this moment the shared parameter dialog should look as follows:

Click to view larger image

Shared Parameter Dialog - "Start Date" Parameter

Now, click the OK button. This will put you back to the shared parameters dialog. As you can see the new shared parameter Start Date has been added to the shared parameters list.

Share Parameters Dialog - "Start Date" Parameter Added

Next, we will add the second shared parameter End Date in the same way as mentioned above. From the dialog, click the Add Share button again, which will open the shared parameter dialog. Enter the parameter name and the prompt name End Date and then select all the End Date parameters from the list on the left. After you have selected all the parameters, click the Add button.

Click to view larger image

Shared Parameter Dialog - "End Date" Parameter

Then click OK button. After adding both parameters you should see the same shared parameters dialog as follows:

Shared Parameters Dialog - Added Parameters

In the dialog, select both parameters by holding the CTRL key and clicking on the parameters as shown in the image below.

Shared Parameters Dialog - Selected Parameters

After selecting the parameters, click Set Range button. This will open the Set Range dialog that allows you to specify ranges for the parameters.

Click to view larger image

Set Date Range Dialog

As you can see there are lot of options in the dialog. Please note that we will describe only the options necessary for the example. For more information about the rest of options, please see Section 5.1.1.3.2 - Parameter Range.

First, specify the Range Name in the text box at the top of the dialog (e.g. DateRange). The name represents the title for the date range panel. Next, specify the prompt text to be Date Range. This text will be then displayed next to the selected date parameter drop-down menu in the date range panel. After entering the names, we will proceed with creating date ranges.

For simplicity, we will add only two date ranges (Year 2003 and Year 2002) in this example. The range Year 2003 will include all the dates in year 2003 (dates from 2003-01-01 to 2003-12-31 in the Year-Month-Day format). Similarly, the range Year 2002 will include all the dates in year 2002 (dates from 2002-01-01 to 2002-12-31).

Now specify the name for the first range in the Option Name text box to be Year 2003. Next, enter the expressions for the Start Date and End Date parameters to be 2003-01-01 and 2003-12-31. Once you have entered the range name as well as the expressions, click Add>> button. This will add the date range to the list of selected ranges on the right.

Similarly, add the second date range Year 2002. As mentioned above, first specify the range name to be Year 2002 and then enter the expressions for the Start Date and End Date parameters as 2002-01-01 and 2002-12-31. After that, just click Add>> button to add the range to the list of selected ranges on the right.

Click to view larger image

Set Date Range Dialog - Specified Ranges

Once you have added both date ranges into the selected date ranges list on the right, click OK button. After that the date range panel will appear.

Click to view larger image

Date Range Panel

Now move the panel above the map as shown on the image below. To move the panel, just click on the panel header and drag it to the desired location. You can also resize the panel by clicking and dragging the lower right corner of the panel. The resizing rectangle will then appear allowing you to adjust the size of the panel.

Click to view larger image

Dashboard With The Date Range Panel

The last thing we will do in this example will be adding links from the map to the chart and report in the dashboard. This will enable sending the State parameter from the map data points to the chart and report.

To set up links from the map, click the Linkage icon from the map header. This will open the Set Up Link dialog below. There are three lists in the dialog. The first list contains all the available data columns and their data types in the source template (in our case Sales By State map). The second list shows all the available destination templates in the dashboard (in our case Product Sales report and Total Sales By Category chart). Finally, the third column contains all the available parameters in the selected destinate template. Please note that the third column will show the parameters only after selecting the destination template in the second list.

Click to view larger image

Set Up Links Dialog

To set up a link from the map to the Product Sales report, select State (String) item in the first list and the Product Sales item in the second list. This will cause showing the parameters from the report in the third list. After that select State(String) item from the third list. This should enable Set button as shown on the image below. To set up the first link, just click the button.

Click to view larger image

Set Up Links Dialog - Link From The Map To The Report

Similarly, set up a link from the map to the Total Sales By Category chart. First, select State (String) item in the first list and the Total Sales By Category item in the second list. This will cause the parameters from the chart in the third list to be shown. Select the State(String) item from the third list. This should enable the Set button as shown on the image below. Set up the second link by clicking the button.

Click to view larger image

Set Up Links Dialog - Link From The Map To The Chart

Once you have set up both links, click the OK button and the dialog will close. At this moment the links from the map should be set up. So if you now click on a data point in the map, the chart and report should refresh according to the data point parameter value.

To finish our dashboard, we just add a dashboard title and choose a dashboard background color. To add the title, click the Insert Label icon from the toolbar. A small rectangle will then follow your mouse cursor. Position the rectangle where you would like to insert the label and click. This should add the label panel into the dashboard. Next, double click to the label panel to edit the label text. Enter e.g. SALES BY STATE DASHBOARD text and click outside of the label panel. You may also want to resize the label because the label is now too small to be the dashboard title. This can be done from the label properties dialog that opens after clicking on the Edit Label Properties icon on the panel header.

Set Label Properties Dialog

From this dialog you can specify various properties for the label. In the dashboard preview screen shot below, we just increased the label font size to 36px in the Text tab, disabled the panel border in the Border tab and set up the label background color to be transparent in the Background tab. For more information about the label properties, please see Section 5.1.1.4 - Inserting Labels.

To change the dashboard background color, just click the Set Dashboard Background icon on the toolbar. This will open the Set Dashboard Background dialog from which you can choose the dashboard background color.

Set Dashboard Background Dialog

Once you have chosen the dashboard background color, you can preview the dashboard by clicking the Preview button on the Dashboard toolbar. The dashboard display will open in a new window. For more information about dashboard features, please see Section 5.1 - Dashboards.

Click to view larger image

Dashboard Preview

Q.7.1.2. Save the Dashboard

Close the dashboard Preview window to return to the main Dashboard Builder interface. Then click the Save button on the toolbar. A dialog will open prompting you to specify a name for the dashboard.

Save Dashboard Dialog

Enter a name for your dashboard and then select Yes to add the dashboard to the Organizer. From the lower drop-down list select the project that you created in Section Q.2.2.1 - Login as User. Click Ok to save the dashboard. The window will then give you a message that the dashboard was saved successfully. Click Ok to close the dialog.

Q.7.1.3. Export Dashboard to PDF

Click the Options button on the Dashboard Builder toolbar and check the option Show toolbar in preview. Click OK to close the menu. Open the dashboard preview window by clicking the Preview button . Then click the Unpack button to open the preview toolbar. You can export dashboard to PDF file by clicking Export button from the preview toolbar.

Click to view larger image

Export Dashboard from Preview

All the reports, charts, SVG Map and other objects in the Dashboard will be exported to PDF file with the exception of Google Map due to licence restrictions.

Alternatively, you may open the same .dsb file in Published Files (for more information please see Section 6.1 - The Menu Page ), open the Dashboard toolbar and Export PDF there.

Note: There may be small differences in the appearance of elements in export (e.g. radio button shape can change from round to square).

Q.7.2. URLs

One automated deployment provided in EDAB is the ability to run dashboards via URL calls to the EDAB server.

To generate a URL, first log into the Organizer, using the steps described in Section Q.2.2 - Start the Organizer. With the Organizer interface open, select the project you created in the left-hand side (Section Q.2.2.1 - Login as User). You will see a list of files added from the previous exercises. Select the QuickStart_Dashboard.dsb file in the organizer (dashboard created above), and click the Generate URL button on the toolbar . A dialog will open, prompting you to specify options for the generated URL.

URL Options Dialog

Click Ok, and the URL will be generated in a new browser window.

Click to view larger image

Generated URL

Now, select the generated URL and copy the text to the browser's location dialog. Then hit enter to run the URL. Because you elected not to pass in the username and password in the URL, you will first be directed to a login dialog.

URL Login Dialog

Enter your username and password in the dialog, and click the Login button. The dashboard will then load in the browser.

Q.7.3. The Menu Page

Another way that EDAB automatically publishes dashboards is through the Menu Page. The Menu is a thin-client interface that allows users to run/view the dashboards to which they have access in the Organizer.

To launch the Menu, go to the EDAB Start page and login using the user created in Section Q.2.1 - Create a User. After logging in, click the link labeled View Published Dashboards, and the Menu page will load.

Click to view larger image

Menu Page

The page contains a list of all the dashboards in your project. Click the View button for the dashboard you created earlier.

For more information about the options and functions available in the menu page, see Section 6.1 - The Menu Page. After you have finished viewing your dashboard, close the window that contains it, and click the Home button in the menu interface to return to the start page.