Pentaho Report Designer: Creating a Bar-Line chart with secondary

Pentaho Report Designer: Creating a Bar-Line Chart with Secondary Axis in Different FormatTutorial DetailsSoftware: PRD 3.8 (download here)Knowledge: Intermediate (To follow this tutorial you should have good knowledge of the software and hence not every single step will be described)Tutorial files can be downloaded herePentaho Report Designer offers a wider variety of chart types. Today we will look at the bar-line chart type. We will...

Read More

Kettle: Sourcing data from Hadoop Hive

Pentaho Data Integration (Kettle): Sourcing data from Hadoop HiveTutorial DetailsSoftware: PDI/Kettle 4.1 (download here)Knowledge: BeginnerHas your company recently started using Hadoop to cope with enormous amounts of data? Have you been using Kettle so far for your ETL? As you are probably aware of, with the Kettle Enterprise Edition you can now create map-reduce jobs for Hadoop. If you want to stay with the open source version, the good news...

Read More

Tutorial Aggregated Tables for Mondrian (Web)

Tutorial Aggregated Tables for Mondrian(Republished Tutorial - originally published July 2009)For better readability please open this article as Google Document here.RequirementsKnow what you are up toHow to enable MDX and SQL logging on BI Server 3How to configure Mondrian to recognize aggregated tablesTable NamesColumn NamesYour first aggregated tablesAggregated table for login channelAggregated table for countryMake use of aggregates in other programsI've started using Pentaho BI Suite in early 2009. One of my main objectives was to create a...

Read More