What Useful Resources for Pentaho BI CE?

SagoBI looks complex and it takes time to get familiar as compared to http://art.sourceforge.net

I proceed to try out Pentaho BI CE instead, here are the resources I have adopted in my journey:

Suites and Plugins

• This post got the latest update (CE 4.5). This post provides very comprehensive checklist for all the things to be install:  http://interestingittips.wordpress.com/2011/04/27/complete-pentaho-installation-on-ubuntu-part-1/
• Pentaho BI Server CE 3.7 setup but the step-by-step modifications to be perform on the various xml files is clearer than interestingtips -  http://www.prashantraju.com/projects/pentaho/
• Further instructions including including saiku and ctools 
• http://pablotips.blogspot.sg/p/installing-tomcat-and-pentaho.html
• How to add Saiku, BI Server and JPivot OLAP datasource?
• http://interestingittips.wordpress.com/2011/05/08/complete-pentaho-installation-on-ubuntu-part-3/
• The "Eclipses" to download  http://interestingittips.wordpress.com/tag/pentaho-tools/
• Pendular - Another front-end for Pentao BI Server

What interestingtips missed out?

• Recently released : Saiku Report 1.0 ( http://mgiepz.github.com/saiku-reporting/)
• OpenI ( http://openi.org/)

Patches

• Things to modify for the charts in examples to run  http://interestingittips.wordpress.com/2011/05/05/complete-pentaho-installation-on-ubuntu-part-2/
• How to remove the warning messages?  http://interestingittips.wordpress.com/2011/06/05/complete-pentaho-installation-on-ubuntu-part-5/

Tutorials

• Creating Dashboards with CDE:
• http://type-exit.org/adventures-with-open-source-bi/2011/06/creating-dashboards-with-cde/ (no need to seperately download CCC)
• How to join two fact tables with Pentaho Metaeditor?  http://diethardsteiner.blogspot.sg/2011/02/pentaho-metadata-editor-joining-two_04.html

Documentation

• Pentaho Mondrian 3.0.4 Guide  http://docs.huihoo.com/mondrian/