My First Dashboard
15min dashboard ..
So let's dive right in ..
In this workshop we're going to build a simple dashboard based on the SteelWheels Mondrian data source.
The aim of the workshop is to create a '15min dashboard' that introduces:
• OLAP Chart Wizard
• CDE components
Don't worry about all he features & options .. We'll be diving into each perspective in the next set of workshops.
To create a New Dashboard
Log in Pentaho Server -> Create New -> CDE Dashboard.
Click on the Template option.
Select: Two x One Template
The resulting Dashboard is composed of:
• 5 main rows
• body row is split into 2 columns
• the first column is split into a further 3 rows
• the first & third rows have columns which hold Panel_1 & Panel_2
• Panel_3 is held in the second column
• further rows define header, footer and spacers
Click on 'Save as ..' in the toolbar & enter the following details.
Preview the dashboard (eye icon - top right).
Let's start with the Header & Footer rows..
Header Row
Expand the Header row until you reach the HTML Property.
Click on the ... and edit the HTML - we're going to enter some padding to align the text.
<h2 style="color:#FFFFFF; padding: 15px 0">My First Dashboard</h2> Click on the Preview icon - last one in toolbar.
Footer
Create a folder: /resources/img
Upload: logo_pentaho.png
Expand the Footer row until you reach the HTML property.
Edit the HTML
<a style="position:relative;top:5px; right:15px; float:right; color:#FFFFFF;" " border="0" title="Pentaho Professional Services" href="https://pentaho.com/pentaho-professional-services/">
<img src="./resources/img/logo.png"/> Pentaho Professional Services</a> Change the Footer column color to match the logo.
BackgroundColor: #3c4484Dont forget to click on the color wheel ..
Save & Preview the dashboard.
Bit of background info ..
Schema WorkBench is a Pentaho Design Tool used to define a multidimensional MDX schema.
• Cube - is the FACT table in a STAR schema.
• Dimensions - map to the database tables.
• Levels - map to the database columns in the table. The order defines the 'paths' you can take to 'slice& dice' the data.
If you need to 'slice & dice' your data, then you will have spent many hours in Schema Workbench, defining your OLAP reporting cubes.
CTools - OLAP Chart Wizard - can leverage the schema.xml that connects to the underlying sampledata database tables.
You can test MDX queries against your cubes..
Add a Chart
Select: Connection Perspective.
Click on OLAP Chart Wizard & enter the following details:
Name
Total_Sales
Html Object
Panel_3
Catalog
SteelWheels
Cube
SteelWheelsSales
Dimensions
Territory
Measures
Sales
Click OK.
Save & Preview dashboard.
Looks like we made need to apply a few tweaks to align and so on ..
Let's add our other Charts and then take a look at the Chart Components.
Again .. Click on the OLAP Chart Wizard & enter the following details:
Name
Line_Sales
Html Object
Panel_1
Catalog
SteelWheels
Cube
SteelWheelsSales
Dimensions
Line
Measures
Sales
Click OK.
Save.
Again .. Click on the OLAP Chart Wizard & enter the following details:
Name
Years_Sales
Html Object
Years_Sales
Catalog
SteelWhels
Cube
SteelWheelsSales
Dimensions
Years
Measures
Sales
Save and Render.
These components are configured with a set of Properties.
Chart Component
Click on the Components option in the toolbar.
As you can see .. the Wizard has automatically added 3 Chart components with their associated properties.
Highlight the CCC Pie Chart Component.
Edit the following property values:
Title
Total Sales
Height
400
Highlight the CCC Line Chart Component.
Edit the following property values:
Title
Product Line Sales
Legend
False
Highlight the CCC Bar Chart Component.
Title
Yearly Sales
Legend
False
Again Save & Preview the dashboard.
Unless you have previously created the Charts, you will need to make some adjustments to the Layout.
Click on the Layout option and enter the following details:
Row 3 Body
Height
720
Column 1-1 Row 1
Height
360
Column Panel_1
Height
355
Row 3-3
Height
360
Column 1-2 Panel_2
Height
355
Column 2 Panel_3
Height
725
Text Align
Center
The Steel Wheels Inc sampledata dataset resides on a MariaDB.
Based on the ER diagram, we can build our SQL Query, restricting to YR 2004.
Download the MariaDB JDBC driver.
Stop the Pentaho Server
cd
cd /opt/pentaho/server/pentaho-server/
sudo ./stop-pentaho.shCopy the driver to the ~/opt/pentaho/server/pentaho-server/tomcat/lib/ directory.
// Some codeRestart the Pentaho Server.
cd
cd /opt/pentaho/server/pentaho-server/
sudo ./start-pentaho.shOnce logged in select: Manage Data Sources.
Click on the Cog wheel and from the drop-down menu, select: New Connection
Enter your connection details in the selected database panel.
Test the database connection.
If connecting to a Mondrian schema, ensure the connection name is the same as the schema connection name.
Last updated
Was this helpful?