Page Operations
Browse SpaceEvery week the Pentaho team makes a concerted effort to improve our documentation. As anyone who has worked on an open source project can attest, there is never enough time to write all of the code you want to write and write all of the documentation you would like to accompany it.
Fortunately, we have a strong community that graciously contributes gems via forums and email discussions on successfully tackling frequently performed tasks. So we have dedicated this portion of our developer's site to publishing these technical gems so that the rest of the community can benefit from tested, "single-path-of-execution" solutions to everyday problems. Hopefully, you will find just the solution you are looking for here. If not, you can always post your dilemma in our forums here.
If you have an idea for a tech tip you would like to write, please contact communityconnection@pentaho.org
Please get involved and send us feedback on these articles!
Pentaho Platform and Solution Articles
Pentaho Tech Tips
- XQuery Report — September 08, 2008
Submitted by Eric Landry, Pentaho Community Member - Enabling the iPhone BI Extension — July 09, 2008
Submitted by Will Gorman, Pentaho Senior Engineer - Change the name of the HIBERNATE database — March 02, 2007
Submitted by David Kincade, Pentaho Team Developer - Pentaho reports integration with portlets web application — October 07, 2007
Contributed by Ashish Sarin, Pentaho Community Member - A Dashboard Framework for the Pentaho BI Platform — August 21, 2007
- Dynamic Reporting using the ReportSpec API (work in progress) — March 02, 2007
Submitted by Mike D'Amour, Pentaho Team Developer - Using PostgreSQL 8.x for Hibernated Data in the Platform — February 28, 2007
Submitted by Marc Batchelor, Pentaho Team Developer - Dynamically Generating a Cross Tab Report, Part 2 — September 12, 2006
Contributed by Nic Guzaldo, Pentaho Community Member - Dynamically Generating a Cross Tab Report, Part 1 — September 12, 2006
Contributed by Nic Guzaldo, Pentaho Community Member - The IF Statement and PREPARE - Building Flexible, Secure and Scalable Solutions — October 11, 2006
Submitted by Marc Batchelor and Doug Moran, Pentaho Team Developer - Using AJAX to Drive Dependent Report Parameters — January 23, 2007
Submitted by Mike D'Amour, Pentaho Team Developer
External Articles
- Using Open Flash Charts in the BI Platform — August 07, 2008
Contributed by Nick Goodman, Pentaho Community Member - Pentaho on Glassfish, the Step-by-Step Installation — July 23, 2006
Contributed by Stephane Paquet, French blogger - Hands on: MySQL Samples For Pentaho 1 (Installation of the PCI) — July 10, 2006
Contributed by Roland Bouman, MySQL AB, Netherlands - Hands on: MySQL Samples For Pentaho 2 (Configuration of the PCI) — July 12, 2006
Contributed by Roland Bouman, MySQL AB, Netherlands - Hands on: MySQL Samples For Pentaho 3 (Making the MySQL Directory) — July 16,2006,
Contributed by Roland Bouman, MySQL AB, Netherlands - Pentaho on Glassfish Quick and Dirty —
Contributed by Stephane Paquet, French blogger - Step by Step - Setting Up a custom solution repository— September 10, 2007,
Contributed by Michael Tarallo, Pentaho Corportation - Business Intelligence mit Pentaho [German]— Dezember 10, 2007,
Contributed by Marcus Held and Ingo Klose, SHS VIVEON AG - Pentaho AJAX Guide— September 10, 2007,
Contributed by Michael Tarallo, Pentaho Corportation
Pentaho Data Integration Articles
Pentaho Tech Tips
- PDI Performance tuning check-list — Mar 31, 2008
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Executing Job or Transformation packaged in a zip file — Mar 30, 2008
Submitted by Feris Thia, Pentaho Community Member - Mappings re-visited (version 3 or higher) — February 27, 2008
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Step error handling codes — January 17, 2008
Submitted by Matt Castors, Chief of Data Integration, Pentaho - PDI Plugin Loading — Sep 24, 2007
Submitted by Alex Silva, Pentaho - Javascript and Java Object Access in Kettle — March 30, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Helpful Tips and Tricks Using Kettle — April 14, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Looking Up Information in Kettle — April 14, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Mappings in Kettle — May 9, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Using Variables in Kettle — May 23, 2006
- How to Configure Kettle's Spoon for a Pentaho Solution — May 25, 2006
Submitted by James Dixon, Pentaho Chief Geek - Use Kettle to Migrate Sample Data to MySQL — July 11, 2006
Contributed by Nic Guzaldo, Pentaho Community Member - Loading Binary Objects With Kettle — August 23, 2006
Submitted by Matt Casters, Chief of Data Integration, Pentaho - Evaluating Parameters in Kettle Jobs — August 24, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Using the Copy Table Wizard — August 24, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho - Auditing and Operational Metadata — September 1, 2006
Submitted by Matt Castors, Chief of Data Integration, Pentaho
External Articles
- Great Overview of Kettle — June 10, 2006
Contributed by Roland Bouman, MySQL AB, Netherlands - UPSERTS Using Kettle and MySQL — May 4, 2006
Contributed by Nicholas Goodman, Pentaho blogger extraordinaire - Using Java Locale to create a date dimension — September 4th, 2007
Contributed by Roland Bouman, MySQL AB, Netherlands - Kettle und die Entwicklung eines eigenen Plug-ins (German) — September, 2007 [Java Magazin 10.2007]
Contributed by Jens Bleuel, Pentaho - Studie zur Entwicklung eines Data Warehouses zur Auswertung von SAP-Controlling Daten an der Wirtschaftsuniversität Wien (German) - February, 2006
Written by Martin Bernsteiner. [Development of a Data Warehouse for analysing SAP-Controlling Data at the Vienna University of Economics and Business Administration]
- Busines Solutions using PDI (In Open Document Text Format) - 2 May 2008
A work in progress text consisting of case studies and examples on solving common business problems with PDI.
Contributed by Pradesh Chanderpaul, DataCraft Software, South Africa
Pentaho Reporting Articles
Pentaho Tech Tips
- Designing Reports With MySQL and JNDI — May 4, 2006
Contributed by Lee Mewshaw, Red Hat - Setting Up Parameters With the Design Studio — May 17, 2006
Submitted by Doug Moran, Pentaho Team Developer - Introducing the Pentaho Report Designer — May 31, 2006
Submitted by Mike D'Amour, Pentaho Team Developer - Dynamically Generating SQL... And More — June 8, 2006
Submitted by Marc Batchelor, Pentaho Team Developer - Embedding Charts in Pentaho Reporting — June 27, 2006
Submitted by Mike D'Amour, Pentaho Team Developer - Localizing a Pentaho Report — July 13, 2006
Submitted by Mike D'Amour, Pentaho Team Developer
External Articles
- Reporting in 60 Seconds — June 1, 2006
Contributed by Nicholas Goodman, Pentaho blogger extraordinaire - Connect to Your Own Database — May 4, 2006
Contributed by Nicholas Goodman, Pentaho blogger extraordinaire
Pentaho Analysis Articles
Pentaho Tech Tips
- Evaluating Pentaho Analysis — March 25, 2008
- MDX Calculations - Previous Period Growth — October 24, 2006
Contributed by Chris Webb, Crossjoin Consulting - MDX Calculations - Percentage Shares and Allocations — November 7, 2006
Contributed by Chris Webb, Crossjoin Consulting - MDX Calculations - Set Functions — January 15, 2007
Contributed by Chris Webb, Crossjoin Consulting
External Articles
- Trend Lines in Mondrian — November 1, 2006
Contributed by Nicholas Goodman, Pentaho blogger extraordinaire - The Power of OLAP, Part 1: Building a Custom MDX Measure — June 8, 2006
Contributed by Nicholas Goodman, Pentaho blogger extraordinaire - The Power of OLAP, Part 2: Bringing the Power to Your Users — June 9, 2006
Contributed by Nicholas Goodman, Pentaho blogger extraordinaire