Posted under BI Server, Pentaho, Tutorials
Yep, you read right, I have now updated the guide so that it now includes Microsoft SQL Server 2005+. Big thanks goes out to Roland Bouman who sent me the necessary configurations files and drivers needed for this to work, so head over to his blog and give him a hug or just thank him.
You can grab a copy of the guide in Google Docs format and the SQL Script Pack at the projects page.
As always please let me know if you find any errors and also if you would like to see any further additions to guides and support for other databases.
Prashant.
Posted by
Prashant Raju on Aug 30, 2010 —
6 Comments
Posted under BI Server, Open Source, Pentaho, Tutorials
Updated 16/06/2010
This guide has been tested and works with the latest version of Pentaho BI Server 3.6.
Read the rest of this entry»
Posted under Data Integration, Open Source, Pentaho, Tutorials
Using arguments with Pentaho Data Integration (PDI) transformations are extremely handy when trying to pass through dynamic information. In this tutorial I will show how you can implement variables (denoted by ?) within SQL statements using Table input steps. Along with using variables I also cover how to copy and get rows from the result (memory), how to use system information and debugging steps. This tutorial was done with version PDI 3.2.0.
Read the rest of this entry»
Posted by
Prashant Raju on Jun 12, 2010 —
1 Comment
Posted under Open Source, Pentaho, Report Designer, Tutorials, Visualisation
Pentaho Report Designer’s (PRD) charting capability is great – it has numerous charts to choose from and the formatting is extremely flexible. However I did have a problem with charts represent large data sets. For example I had a list of countries and a bar chart showing the population for each country, users were able to view one or more countries at a time using a multi value list parameter. The problem occurred when there were too many countries, the chart’s labels became unreadable. One method was to create a chart which had a dynamic width depending on the amount countries a user selected.
Read the rest of this entry»
Posted by
Prashant Raju on May 17, 2010 —
3 Comments
Posted under Pentaho, Report Designer, Tips, Tutorials
Multi list parameters (multi list values and multi selection buttons) are a great way of letting a user filter a report on one or more values at once. Recently I came across a situation where I had to display these values in a friendly format. This tip will outline a method I used to display friendly formatted parameter values of a multi list parameter inside a report using Pentaho Report Designer 3.6.
Read the rest of this entry»
Posted by
Prashant Raju on Apr 15, 2010 —
7 Comments
Posted under Pentaho, Report Designer, Tutorials, Visualisation
Last week I had a regular Excel/Access user approach me with a problem:
I have 40 sale campaigns. I need to put together a quick presentation (as a PDF) which will show 2 key metrics (New and Loss revenue) for each of the 40 sale campaigns. Do you know of a quick way I can produce this presentation?
I thought this would the perfect opportunity to show off Pentaho Report Designer (PRD) as an alternative to Mircosoft Excel, Access or other big BI vendors. Below is a step by step guide on how I accomplished this.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 4 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:
In this post I will show you how to customise the launch page.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
With the recent release of Pentaho’s BI Server 3.5.2 and Tom Barber’s (aka magicaltrout) post I thought I would put together a quick tutorial on how to use a new feature of 3.5.2 which allows end users to email reports directly from the Pentaho User Console (PUC).
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 3 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:
In this post I will show you how to customise the main-toolbar, menu-bar, logo-panel and other features for the PUC.
Read the rest of this entry»
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.
Read the rest of this entry»
Posted by
Prashant Raju on Feb 18, 2010 —
4 Comments