Technical Tips
Every 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
- Scheduling xactions from the Pentaho Admin Console
- Run bi-server in another port and address
- Integrate CDF and CDA with Twitter and Google Maps
- Enable POST-Method for xactions
- XQuery Report — September 08, 2008
- Enabling the iPhone BI Extension — July 09, 2008
- Change the name of the HIBERNATE database — March 02, 2007
- Pentaho reports integration with portlets web application — October 07, 2007
- A Dashboard Framework for the Pentaho BI Platform — August 21, 2007
- Dynamic Reporting using the ReportSpec API (work in progress) — March 02, 2007
- Using PostgreSQL 8.x for Hibernated Data in the Platform — February 28, 2007
- Dynamically Generating a Cross Tab Report, Part 2 — September 12, 2006
- Dynamically Generating a Cross Tab Report, Part 1 — September 12, 2006
- The IF Statement and PREPARE - Building Flexible, Secure and Scalable Solutions — October 11, 2006
- Using AJAX to Drive Dependent Report Parameters — January 23, 2007
External Articles
- CDA configuration files basics part 1, part 2, part 3---July , 2010
Contributed bySergio Ramazzina, Pentaho Community Member - Easily build BI Server from behind an NTLM proxy— April 28, 2010
Contributed by Sergio Ramazzina, Pentaho Community Member - Step by Step: Customising the Pentaho User Console - Launch Page — March 10, 2010
Contributed by Prashant Raju, Pentaho Community Member - Step by Step: Customising the Pentaho User Console - Menu Bar, Main Toolbar and Logo Panel— March 03, 2010
Contributed by Prashant Raju, Pentaho Community Member - Step by Step: Customising the Pentaho User Console - Messages— February 17, 2010
Contributed by Prashant Raju, Pentaho Community Member - Step by Step: Customising the Pentaho User Console - Login Page and Dialog— February 14, 2010
Contributed by Prashant Raju, Pentaho Community Member - Hands On: BI Server and MS Active Directory— February 18, 2010
Contributed by Sergio Ramazzina, Pentaho Community Member - Step by Step: BI Server 3.6 with MySQL, PostgreSQL and Oracle on Linux and Windows — January 9, 2010
Contributed by Prashant Raju, Pentaho Community Member - Hands on: BiServer 3.5 PostgreSQL SSL — December 26, 2009
Contributed by Flavio Torres, Pentaho Community Member - 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
- Kettle Telemetry and Usage Statistics
- PDI with Agile BI plug-in on Ubuntu 12
- PDI One liners and quick tips
- Running kettle transformation using Java
- Configuring Kettle VFS
- Quick Recipes
- PDI Performance tuning check-list — Mar 31, 2008
- Executing Job or Transformation packaged in a zip file — Mar 30, 2008
- Mappings re-visited (version 3 or higher) — February 27, 2008
- Step error handling codes — January 17, 2008
- PDI Plugin Loading — Sep 24, 2007
- Javascript and Java Object Access in Kettle — March 30, 2006
- Helpful Tips and Tricks Using Kettle — April 14, 2006
- Looking Up Information in Kettle — April 14, 2006
- Mappings in Kettle — May 9, 2006
- Using Variables in Kettle — May 23, 2006
- How to Configure Kettle's Spoon for a Pentaho Solution — May 25, 2006
- Use Kettle to Migrate Sample Data to MySQL — July 11, 2006
- Loading Binary Objects With Kettle — August 23, 2006
- Evaluating Parameters in Kettle Jobs — August 24, 2006
- Using the Copy Table Wizard — August 24, 2006
- Auditing and Operational Metadata — September 1, 2006
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 - HowTo setup a repository for Pentaho — March 17, 2009
A new user who is evaluating or discovering all the possibilities available with Pentaho may find it difficult to get the first repository database setup. This article aims at giving a helping hand with this task.
Contributed by Gustav Schaffter - Quick Recipes — Ongoing updates
Quick recipes for some common basic tasks.
Contributed by NilsB - Using Variables ( ? ) with Table Input Steps— June 12, 2010
Contributed by Prashant Raju - Pentaho Community Member - Processing group of files executing a job once per file — August 26, 2010
Contributed by Sergio Ramazzina - Pentaho Community Member - Configure Kettle debug session (on SlideShare IT Lang http://www.slideshare.net/amusarra/configure-kettle-debug-session) -- February 21, 2011
Contributed by Antonio Musarra (Italia) - Running Kettle Job by API (on SlideShare http://www.slideshare.net/amusarra/running-kettle-job-by-api) -- March 28, 2011
Contributed by Antonio Musarra (Italia)
Pentaho Reporting Articles
Pentaho Tech Tips
- Customizing your Pentaho Metadata Query in Pentaho Reporting — May 12, 2011
- Creating an Address Label Report
- Data types and parameter passing from Report Designer 3.6 to the 3.5.2 platform
- Getting Report Parameter Choices from the Database
- Designing Reports With MySQL and JNDI — May 4, 2006
- Setting Up Parameters With the Design Studio — May 17, 2006
- Introducing the Pentaho Report Designer — May 31, 2006
- Dynamically Generating SQL... And More — June 8, 2006
- Embedding Charts in Pentaho Reporting — June 27, 2006
- Localizing a Pentaho Report — July 13, 2006
External Articles
- Dynamic Sizing Charts with Pentaho Report Designer — May 17, 2010
Contributed by Prashant Raju, Pentaho Community Member - Displaying Multi-Value Parameters with Pentaho Report Designer — Apr 15, 2010
Contributed by Prashant Raju, Pentaho Community Member - Pentaho Report Designer and Excel Data Sources — Apr 8, 2010
Contributed by Prashant Raju, Pentaho Community Member - Creating Cascade Parameters with Pentaho Report Designer — Feb 18, 2010
Contributed by Prashant Raju, Pentaho Community Member - Parameter Types with Pentaho Report Designer — Jan 28, 2010
Contributed by Prashant Raju, Pentaho Community Member - Creating Parameters with Pentaho Report Designer — Jan 28, 2010
Contributed by Prashant Raju, Pentaho Community Member - 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
- Mondrian Cache Priming and Cache Control in the BI Server — June 13, 2011
- Evaluating Pentaho Analysis
- MDX Calculations - Previous Period Growth — October 24, 2006
- MDX Calculations - Percentage Shares and Allocations — November 7, 2006
- MDX Calculations - Set Functions — January 15, 2007
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