Archive for the 'platform' Category

Experimental Action Editor in GWT

I wanted to share with everyone a new open source project that I just released out to Google Code.  When using Pentaho’s BI Server, users create Action Sequences to pull their data from a warehouse and display it in a Report, etc.  Pentaho’s Action Sequences make it easy for business analysts to define their own process. Pentaho offers Action Components ranging from Analysis OLAP Views to XML Queries that can be combined to create an Action Sequence. Today, you can use one of our many wizards to generate an Action Sequence, or generate one with our Design Studio, a thick client application built on Eclipse.

To educate myself in Google’s Web Toolkit (GWT), I decided to attempt a port of our Design Studio over to thin client. I’ve made a lot of progress, including getting Dom4J running in GWT along with Pentaho’s Action Sequence DOM, an important library that parses and builds a document object model of an Action Sequence file. This week I’ve uploaded the first set of code, which implements input, resource and output parameter management, as well as the start of a couple Action Components, including SQL Lookup Rule and the JFreeReport Component. The project includes instructions to integrate into our latest BI Server, so you can right click, select “Edit Action”, and start editing your Action Sequence right in the browser!

If there are folks out there interested in contributing to this project, please feel free to check out the code, help out with requirements, graphics, you name it! I’ll be working on the project in my spare time.

DOM4J4GWT
This is a light DOM4J Implementation, designed to run within GWT’s client environment
http://code.google.com/p/dom4j4gwt

Penaho Action Sequence DOM 4 GWT
This project modifies Pentaho Action Sequence DOM so that it may run within GWT’s client environment
http://code.google.com/p/pentaho-actionsequence-dom-4gwt

Pentaho Action Editor
This is the main project, that allows you to edit Pentaho’s Action Sequences in the browser. It includes instructions for deploying into Pentaho’s 2.0 BI Platform
http://code.google.com/p/pentaho-actioneditor

Pentaho BI Server Community Edition, 2.0 RC1

This week, the Pentaho team released our first release candidate of our 2.0 Business Intelligence Server.  The entire Orlando team worked many months on the brand new features incorporated into this release.  I’m going to highlight some of the most exciting features that we’re all proud of at Pentaho:

A New User Console
In this release, we built from the ground up an entirely new user interface designed to greatly enhance the user experience of our Business Intelligence Server.  Taking advantage of Google’s Web Toolkit’s amazing technology, we were able to deliver a complete Web 2.0 dynamic experience to our business users.  We’ve modernized the look and feel of our analysis views and adhoc reporting tool, along with greatly simplifying permissions management.

Data Source and User Management
For the first time, our Community Edition Business Intelligence Server also comes shipped with an Administration console, for management of Users and Relational Data Sources.  In addition to our default support for direct JDBC and JNDI connections, we also have the ability to define a Pentaho Managed Data Source.  This makes it easy for business users to add their own data sources, without having to know the ins and outs of the Java Enterprise Container hosting Pentaho’s BI Server.

Metadata Row Level Security
Another important enhancement to our product offering is the ability to manage row level security from within our Metadata Layer.  In our first release of Pentaho Metadata, we implemented Model, View and Column Level Security.  In this release we extend our Security functionality to also include Row Level Constraints.  Check out the documentation!

There are countless other features that went into our Community Edition release.  At the same time, we’re also releasing our Enterprise Edition software, which includes features such as enhanced ETL Administration, along with many additional BI Server Administration and Configuration capabilities.  These are exciting times!

Pentaho iPhone Coverage, Post on YouTube

Today I saw that Pentaho’s Business Intelligence iPhone Softare made it into Network World’s 20 cool third-party iPhone apps list. Check out slide 11! Very cool. Also, I posted the video over to youtube for all to share:

log4j, Mondrian MDX and SQL Logging

I’ve always struggled to get log4j working perfectly within the Pentaho BI Platform.  Before the release of JBoss 4.2.1, there was a log4j.xml conflict between JBoss’s config and regular web applications.  Now that Pentaho 1.7 PCI by default runs in JBoss 4.2.1, we finally have a hastle free way to manage logging.

We can now manage all of Pentaho’s logging within the pentaho war’s WEB-INF/classes/log4j.xml file.  Another reason why this is important to note is that Mondrian’s SQL and MDX logging, something we’re always taking a look at, moved from a Mondrian debug property to a log4j category in Mondrian 3.0.  To get MDX and SQL logging out of Mondrian:

Add two new categories to the log4j.xml file:

<category name="mondrian.sql">
<priority value="DEBUG"/>
</category>

<category name="mondrian.mdx">
<priority value="DEBUG"/>
</category>

Also, you’ll want to remove the explicit Threshold element from within the appenders.  When a Threshold is defined in an Appender, it overrides the individual category thresholds.  log4j is a powerful logging tool, but sometimes it can be difficult to configure.