Updated 28/02/2010
This guide has been tested and works with the latest version of Pentaho BI Server 3.5.2.
Pentaho 3.5.x with MySQL, PostgreSQL & Oracle.
Posted under BI Server, Open Source, Pentaho, Tutorials
Creating Cascade Parameters with Pentaho Report Designer 3.5.
Posted under Open Source, Pentaho, Report Designer, Tutorials
Cascade parameters provide a way of managing large amounts of data in reports. You can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter.
In this example I will be using the Steel Wheels sample data to create a report which will display a list of customers using two parameters: a drop down parameter which will contain a distinct list of countries which will then filter another drop down parameter which contains cities which belong to the country.
Customising the Pentaho User Console – Part 2.
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 2 of the series “Customising the Pentaho User Console (PUC)” Version 3.5.x. Here is a list of what I have covered in other parts:
- Login page and dialog
- Messages (covered in this post)
- Main toolbar, menu bar and logo panel
- Launch page
In this post I will show you how to customise messages for the login dialog and PUC.
Customising the Pentaho User Console – Part 1.
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
For the past couple of weeks I have been playing around with customising the Pentaho User Console (PUC) Version 3.5.x and to follow it up I thought I would put together a multi-part post on the topic. Each post will cover one aspect of customising the PUC, these include:
- Login page and dialog (covered in this post)
- Messages
- Main toolbar, menu bar and logo panel
- Launch page
In this post I will show you how to customise the default login dialog and how to create a new login page.
Free Tools to Create Sparklines.
Posted under Open Source, Pentaho, Visualisation
Sparklines are an invention by Edward Tufte and are a great way to provide a bare-bones and space efficient time-series context for measures (Few, Stephen. 2006. Information Dashboard Design). If you would like to read more up on Sparklines I suggest you get Edward Tuftes book Beautiful Evidence – there is a whole chapter dedicated to Sparklines.
Below is a list of open source and free tools which support or are dedicated to creating Sparklines or Microcharts.
VisualPlace – A Victorian Government Map Mashup.
Posted under News, Visualisation
In December 2009 the Victorian Government released a “proof of concept” mashup with demographic and government services data known as VisualPlace.
VisualPlace is a six month Proof of Concept testing innovative ways of capturing, exploring and visualising government information and services through maps. VisualPlace brings together information from a wide variety of sources from service locations to demographic data to allow you to create custom maps.