Dashboards, Applications & Business Intelligence

In the previous post, we saw how to connect to a database.

We will continue with the creation of first cut of our dashboard

Click on the New Dashboard button or from the menu bar, select Create -> Dashboard

Enter an appropriate name for the dashboard => Sales Analysis

Click OK

The result should be a blank dashboard as shown below.

Now we will add our first Qlet (short for Portlet based on SQL Query)

A Qlet dialog will open up as shown below.

Provide the name of the Qlet : Sales Fact

Select the Connection from the list

and enter the Sales Fact query in the text area shown above

Select *
from video5.sales_fact

NOTE: Optionally you may choose to add individual columns in the select query

Click on the Apply button

You should see the following results

continued…. Add parameter to Dashboard