Hi all. I'm not sure how to depict my question else this video (http://www.youtube.com/watch?v=K7aMVV5LsEU). I can manage info with Pentaho analysis views, but I'm not sure if I can modify analysis views, or maybe I have to find a third party BI plugin. Thanks in advance for your help
A:
What you're wanting to do is create a Pivot Table/Chart in Pentaho.
You have three choices currently, two are FOSS, and the third is in the Enterprise Edition.
You can use the built in Mondrian OLAP database to build an (R)OLAP cube. This cube will be the equivalent of the Pivot Table. You'll then be able to use either of the FOSS viewers available to the BI suite. The one that is built in is called JPivot and can be a bit clunky.
The alternative, Pentaho Analysis Tool (http://code.google.com/p/pentahoanalysistool/), is shaping up to be a real contender to the Analysis viewer available in the Enterprise Edition. They are close to releasing version 1.0 which will hopefully be adopted by the Community Edition.
The third option will cost the price of an Enterprise Liscense. It's pretty powerful from what I've seen (I use Community Edition, but from watching the tech demos, EE's Analysis Tool is pretty cool).
DBA_Alex
2010-09-24 15:51:33