We recently received a monster (in a great way!!) of a tech tip from Nic Guzaldo, a self-taught Pentaho expert and supporter. I spent a day or so getting my head around what Nic had accomplished (with many exclamations of "wow, I didn't know we could do THAT!"), and figured I should break it up into a series of articles for easier consumption.
This first article of the series focuses on creating a query that will not only demonstrate setting up regular data for a cross tab report, but also use user input to determine the number of columns in the query.
In the second half of this solution, we will continue with Nic's example and use the generated resultset as input to a dynamically generated report spec, to create a Pentaho report that allows a variable number of columns, dynamically generated report name, nice output names for external files and other goodies!
Start test driving this jam-packed solution at here.
Thursday, August 17, 2006
Posted by Gretchen Moran at 5:51 PM
As part of my job at Pentaho, I occasionally get to help build solutions using the Pentaho BI platform and the solution building toolset, De...
We recently received a monster (in a great way!!) of a tech tip from Nic Guzaldo, a self-taught Pentaho expert and supporter. I spent a day ...
Just over 10 years, and it has finally happened. Hitachi Data Systems intends to acquire our baby, Pentaho. I couldn't be more exci...
I had the chance this week to play around with the still-under-construction Pentaho plugin architecture in the Citrus code line. The new ar...
I recently stumbled across this problem with one of Pentaho's applications. When the application was downloaded and installed on a Mac, ...
You really need to check out our demo of Pentaho's Google Maps integration, put together courtesy of Jake Cornelius, Product Manager fo...
Had a bit of fun with Pentaho Analyzer recently. In the release of Pentaho 5.2 , we have introduced the ability to define filters across a r...
Docker. Hmmmm. I really want to love it. Everybody else loves it, so I should right? I think maybe some of the "shiny" isn't s...
I've been gathering some interesting and useful information when dealing with Pentaho Reporting, Pentaho Metadata and characters not rep...
We have a great opportunity to explore how Pentaho can provide ETL, analytics, and reporting benefits to OpenMRS , an open source medical re...
- ▼ August ( 5 )
- Gretchen Moran
- I have been in the Business Analytics and Java development space for seventeen years. I started out as a data warehouse developer for a small insurance company in the Midwest, worked for Hyperion Solutions as a software engineer for a number of years, and came in on the ground floor with the guys at Pentaho. I have a history of moving around, so I have enjoyed working with the community, consulting directly with Pentaho customers and partners and coding with the development team. I am now an Enterprise Architect and consultant for Pentaho, working on various projects.