Tuesday, October 27, 2009

CDF - Dashboard Editor. Version 0.2

Somewhat to my surprise, this is actually working for a lot of people. Thanks for the great feedback everyone.


One of the most pointed issues was the fact that New -> Dashboard didn't work. It was not implemented at all because at the time we developed that (pentaho 3.0 was the current version) the menu hooks didn't work. They do now, so it makes sense to correct it.


Other very annoying bug was that we were unable to save to a folder that had whitespaces


Anyway. Both of it is fixed and 0.2 is just out the door!


Have fun!


(oh, and hire us for the implementations ;) )

Tuesday, October 13, 2009

Pentaho / Lucidera - an excuse for the big questions?

It's amazing the amount of discussion generated by Pentaho's acquisition of ClearView.


The concerns it raised have nothing to do with this move; Everyone agrees it makes sense: Lucidera came to an halt, they had a valuable product and valuable resources, Pentaho took the opportunity and acquired something that fills a gap into it's own offering.


So, what's the problem here? ClearView is only available for paying customers.


This raised a lot of questions and some frustrations. A few hours ago Seth Grimes summed some of the concers in a blog post. Even questioned if Pentaho was shifting strategy, which deserved a prompt response from Pentaho's CTO James Dixon.


I don't agree with Seth in the strategic part. It's not by having closed-source components that Pentaho will stop being an Open Source company (I also like the term open core). They payed money to Lucidera; They make money from the subscribed customers; They want to give more value to those customers. What's the problem?


I do agree with Seth when he says that the message pentaho passes is confusing; I always have the feeling that Pentaho faces an identify problem and is a little bit ashamed of it's closed source components. When we access the main Pentaho page we can hardly tell it's a O-S company. Apart from the logo, everything is "buy, try, evaluate" etc. When we visit the sourceforge page we are clueless about the commercial approach. It's important to clarify that. I'd really like to see in pentaho main page some bold sentence with something like "We are a commercial company; We have an opensource product with some closed source add-ons that give productivity boost to our clients - the ones that pay for our salary".


For me, the million dollar question that has to be answered is:

If my company chooses to go for the opensource version today, will we end up with a stale product one year from now?

When users see something released only in a closed source form, they fear everything from now on will be released as closed source only. It's a genuine fear. We recently saw the Dashboard Designer, the chart editor and now ClearView being released for paying customers only. Pentaho's answer can't be "the community won't let that happen". While the community indeed plays a big role here, Pentaho will always lead the way. The worst that could happen to Pentaho is having the community loosing it's interest. So it's indeed a tough decision for them when they need to make a call if something goes open source or closed source.


But we must not forget something: Pentaho needs it's community. Most of it's business and visibility is made through the open source version and they absolutely can not change that. It's much worst from them as a company than it is for us, community users or paying customers.

Friday, October 2, 2009

Pentaho Reporting Explained

Finally got my hands on The Book! While I was very happy with the overall quality of Pentaho Solutions I have to admit that I was more anxious to get this one;

Thomas Morgner and the JFreeReport team did a very big refactor in version 3.5 of JFreeReport - codename Citrus (so big that was enough to trigger the release of version 3.5 of the Pentaho platform). And Will, as part of the JFreeReport and Pentaho development team was able to sync the release of the book with the release of the software - can't be more up to date than this.

So, not only I have a new software to play with, I also have a new book that will guide me through all the changes and improvements.

The book is not aimed to be an intruction manual on how to use reporting in the Pentaho platform, on the contrary; Will gives extensive instructions on how to use the reporting engine regardless of the environment - a java swing application, a webapplication, whatever; Just call the APIs and you'll get a report in whatever format you want. Of course, the Pentaho platform comes as an added bonus.

It does a great job explaining the structure of the engine, how to work with the report designer, how to integrate with several datasources, the export options, how to call the api and many other subjects. Fortunately it's not one of those books that waste 300 pages with the printed api, so expect to read it from start to end, probably just skipping through some (not very extensive) java code that explains how to do task N that you'll just thank to god that it's there in case you need it. Unfortunately the book can't cover everything; I was hoping to have more details on olap reporting but found only some simpler examples.


Conclusion: If you're planning to do reporting in java/webapps/pentaho/whatever just buy the book and don't complain about missing documentation for the next 2 years

Tuesday, September 29, 2009

CDF - Dashboard Editor. Want a test drive?

If you were in Barcelona for the Pentaho Community Meeting, you know what this is. If you were *not* in there, well... it's a dashboard editor... for CDF.


You can download the package from here . It includes the sample I built in Barcelona. No time for instructions at this time, but shouldn't be hard to find what to do with it.


This is *not* intended for production unless you really know what you're doing. We can't guarantee that it will work for you at this point - we do guarantee that it works for us and our clients, so if you need consulting services for your project contact us.


As I said, the code will be released as open source with some added value services on top of it - as soon as we have time to do it.


Have fun and provide feedback

(ps: the new dashboard button in the menu isn't implemented yet. Open a sample and save with a new name)

Monday, September 28, 2009

Interacting with users: The CDF CommentsComponent

Now that CDF allows us to do most of the "core" stuff when we want to build a dashboard for pentaho, we can aim some steps higher; We're working heavily on allowing users to iterate with the data; In my view, the ideal BI system is not a static application but a place where several users are able to discuss the information to make additional question and draw conclusions.

We just built a new component for CDF that allows users to make comments on a dashboard. Without any additional configuration needed, it stores the comments in the hibernate database of pentaho (gotta love pentaho's customization abilities!) making them persistent.

This will be available in the next CDF version (or trunk, for the ones that use it)

Friday, September 18, 2009

Pentaho Reporting - The book (part 2)

2 book in 2 weeks. Looking great.


Full review will come later when I get my hard copy that I can take to places where the computer is not. But I've read parts of it in the e-book version;


If Pentaho Solutions is the book I'd kill for 2 years ago, Pentaho Reporting 3.5 for Java Developers is the book I want and need now. Will Gorman's book comes in a perfect timing: Pentaho 3.5 is near GA (stable version, for the ones who still didn't understand Pentaho's naming sistem - believe me, takes time to get used to), and ships the newest version of the reporting engine. Thomas Morgner and his team did a great refactor and it's by far one of the biggest improvements done in years.


So, we have a new and much improved reporting engine that comes at the same time as a book that explains in detail how to use it. Who can ask for more?

Monday, September 14, 2009

Pentaho Solutions - The book


Roland Bouman and Jos Van Dongen took 6 months out of their family life and created this. And cutting to the chase, every Pentaho learner should thank them for that.


Pentaho is a very complex application due to many factors. For starters, the BI field is, by definition, a very sensitive field; the fact that pentaho started by combining distinct successful open-source projects - mondrian, kettle, jfreereport and weka - doesn't help when we want to learn exactly what's what. There are so many distinct applications that gets confusing to know what each thing is for.


All this makes the learning curve a very steep one. Until now. Trough over 600 pages Pentaho Solutions does a great job explaining all the Pentaho stack, where each of the components fit it and when to use what. And it doesn't stop there; It's impossible to do anything in Business Intelligence without some very solid knowledge of Data Warehouse. While this book is definitely not about it (this one is) still gives the novice reader the key concepts needed to read the book and go through the practical examples that are used.


The chapters are very well organized. They are in the same order as the topic appear when we are implementing a Pentaho solution. In the end the 600 pages even feel short, so many concepts it introduces. Don't expect to become an expert in pentaho; You won't master any of the components with this book only; you won't be a OLAP guru, a reporting wizard or even a etl master. But you will definitely know where to search for.


In my opinion, the ones that will benefit the most with this books are those guys with emails ending with @pentaho.com. It's so difficult to start playing with pentaho that a lot of newcomers feel scared and abandon it, resulting in a loss of potential user. This book changes all that. I wish I had it when I started playing with pentaho over 2 years ago. And I'm glad I have it know.