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

enter_dashboard_name.png

Click OK

The result should be a blank dashboard as shown below.

new_blank_dashboard.png


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

click_on_new_qlet_button.png

A Qlet dialog will open up as shown below.

new_qlet_details_sales_fact.png

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

sales_fact_qlet_1st_cut.png

continued…. Add parameter to Dashboard