Create New Dashboard

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

Leave a Comment