Wildan M >> OpenThink Labs

Krishnan Shankar , June 2009, Sun Microsystems, Inc. 1. Introduction 1.1 Overview This paper describes a sizing study of Pentaho Open Source Business Intelligence (OSBI) Suite on a Sun platform, including tests conducted with application tools from Pentaho. The purpose is to provide this guide as a reference point when users are choosing a suitable [...]

…………… References : Data Warehousing Tips and Tricks, http://sheeri.net/archives/204 Data Warehousing with MySQL and Infobright, http://dev.mysql.com/tech-resources/articles/datawarehousing_mysql_infobright.html Create costs fact tables, http://etl-tools.info/en/sas_tutorial/costs-fact_table.htm The Feckless Fact Table, http://it.toolbox.com/blogs/confessions/the-feckless-fact-table-14695 Modeling Degenerate dimensions – Fact attributes, http://www.rittmanmead.com/2010/01/20/oracle-bi-ee-10-1-3-4-1-modeling-degenerate-dimensions-fact-attributes/

I’m still investigating and learn more deeply about this topic, meanwhile you can read interesting links below related to this topic : http://www.einfobuzz.com/2010/05/incremental-update-using-pentaho-kettle.html http://forums.pentaho.org/showthread.php?t=58021

FoodMart database is an example database for learning OLAP/data warehoue especially using pentaho BI suite. I found that the easiest way to load the data is using the MondrianFoodMartLoader utility. The following is a simple shell file, put this file on mondrian installation directory, make this file executable and run this file. Don’t forget to [...]