Parameter Types with Pentaho Report Designer 3.5.

Posted under Open Source, Pentaho, Report Designer, Tutorials




Pentaho Report Designer 3.5 came with nine new pre built parameters. Below is a quick overview of the nine parameters. Each overview includes:

  • Screenshot and description
  • How to setup your parameter query
  • How to setup your report query to accept the parameter

Read the rest of this entry»


Creating Parameters with Pentaho Report Designer.

Posted under Open Source, Pentaho, Report Designer, Tutorials




With the release of Pentaho Report Designer 3.5 users can create parameters through the designer rather than having to build a xaction which at times could be messy and confusing. Here is a tutorial on how you can create a basic parameter with Pentaho Report Designer 3.5.

If you aren’t already aware Doug Moran (Pentaho’s Community Leader) has already created a set off screen casts showing off features of Pentaho Report Designer 3.5.

Read the rest of this entry»


Pentaho and the R Project.

Posted under BI Server, Open Source, Pentaho, R

I’m not sure if everyone is aware of this as the recording was released last year but the team at OpenBI have been able to integrate R and Pentaho Business Intelligence Server. The screen cast, which you can view here, was demoed with version 2.0 of the server but I don’t see why it wouldn’t work with version 3.5 (correct me if I’m wrong). The screen cast goes into detail on how the connection between Pentaho and R-Project works and what packages/libraries you will need to get it setup and running.

For those of you who don’t know:

R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS

Along with Weka, R is definitely a tool that I believe all analysts should have handy when performing statistical related tasks.

Enjoy.


Publishing Content with Pentaho 3.5.

Posted under BI Server, Open Source, Pentaho, Report Designer, Tutorials

For those starting out with Pentaho it can be confusing on how to publish content (reports, ETL jobs etc.) to Pentaho Business Intelligence (BI) server. I have put together a guide which outlines the steps you will need to enable publishing and also an example of how you can use Pentaho Report Designer (PRD) to publish reports.

Read the rest of this entry»


Pentaho Solutions Review.

Posted under BI Server, Open Source, Pentaho, Report Designer

Pentaho SolutionsI was about to do a chapter by chapter review of Roland Bouman and Jos van Dangen‘s masterpiece “Pentaho Solutions – Business Intelligence and Data Warehousing with Pentaho and MySQL” but since I started reading it I haven’t been able to put it down. It is definitely a must for anyone who is interested or currently working with Pentaho.

Because this book just oozes with awesomeness I have been able to shorten my review to three words “buy it now“.

Enjoy.


Survey Scale charts with Pentaho Report Designer.

Posted under Open Source, Pentaho, Report Designer, Tutorials

Survey Scale Post PreviewAfter the new release of Pentaho’s Report Designer 3.5 (PRD) I thought I would get stuck into trying out some of the new charting features, of which Survey Scales (and of course Sparklines) interested me the most. Survey Scales are a way of graphically representing values on a predefined scale i.e. survey responses.

Below is a tutorial which I have put together on how to implement Survey Scales within a report using Pentaho’s Report Designer 3.5.

Read the rest of this entry»