Tuesday, December 14, 2010

Pentaho JavaScript API presentation

On this page, there is the video recording of my presentation to the Pentaho Technical group. Code is also over here.

Friday, April 9, 2010

Pentaho Solution Repository JavaScript API

Based on a previous post, I have created a JavaScript API and wrapper for the Pentaho Solution Repository.

System Integrators or others who want to integrate Pentaho into their web applications can use only JavaScript to communicate with the Pentaho BI Platform. No need to parse SOAP responses or otherwise deal with XML at all. It is all JavaScript!

Get the source here.


Monday, March 29, 2010

Pentaho Analyzer - Calculations

In this short video, I demonstrate how to create new calculations that were not provided with Pentaho Analyzer.

Tuesday, March 23, 2010

Simple Pentaho Analyzer videos

I was recently asked by a client, "How do I add report totals and subtotals to my Analyzer report"? I looked around the documentation, knowledge base and wiki. I did not see any straightforward examples, so I decided to answer this and other questions with videos.

If pictures are worth 1,000 words, how many words are videos worth? Anyway, I wanted to create short and simple videos that convey one or two points. There are other, more comprehensive videos out the about Pentaho Analyzer, but these are short and sweet.

Getting Started
This is really bare bones and demonstrates how easy it is to get going.

Totals and Subtotals
Adding report level totals not intuitive, but easy just the same.

Monday, January 25, 2010

Pentaho Javascript API

As Systems Integrator, implementing the Pentaho BI platform is relatively straightforward. However, when you want to customize the User Interface and hook directly into the Pentaho Web Service API's, you need to wade through a lot of code and a little documentation. Additionally, the format of most API's is XML. Web developers like parsing XML about as much as they like having a root canal! I have had to do much of this parsing over the last few years and have started to formulate a way out. I believe that web developers would much rather deal with JSON over XML and use Javascript objects and methods over XMLHTTPRequest. This has taken the shape of a Javascript API for Pentaho. The intent is that it is library agnostic, although the front-end could be YUI, jQuery, dojo, closure or any other library.

In this wiki page, I describe the types of things I would like the API to perform. Some of these are already available as Pentaho Servlets or JSP's, while other require more ingenuity. In the end, a front-end web developer should not need to write java or parse XML to interact with the Pentaho BI Platform.

The current plan is to implement the API in stages. First, I have created the components for interacting with Pentaho Metadata issuing MQL queries here. Next up is Action Sequence interaction and then I will leverage Roland's XMLA4JS for OLAP.