The 10 Seconds Pentaho Metadata Editor Tutorial

Quick Step By Step GuideYou can find the main Pentaho Wiki doc here. This is an updated (2013-08-19) and extended version of the original tutorial which I posted here a few years ago. It will take you more than 10 seconds now to read through it, but instructions should be more precise now than before.Specifying JNDI and adding the JDBC driverDefine a JDNI Connection. You have to use the same JNDI connection as you specified on the BI Server (in the...

Read More

Pentaho Xactions: Prepare your data for the Google Visualization

Pentaho Xactions: Prepare your data for the Google Visualization API We want to create a line chart like the one shown in http://code.google.com/apis/visualization/documentation/gallery/linechart.html . Take a good look at the code below the chart, this is the one that we will try to prepare here.Let's kick off with a simple MDX query that will display the amount of new registrations for the period 2009 Week 10 to Week 22:SELECT [Country].ChildrenON COLUMNS,{[Registration Time Weekly].[2009].[10]:[Registration Time Weekly].[2009].[22]}*{[Measures].[New...

Read More