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
- How to add Saiku, BI Server and JPivot OLAP datasource?
- 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/
