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 put the jars needed by this script at the lib directory.

#!/bin/bash 

java -cp "lib/mondrian.jar:lib/log4j.jar:lib/commons-logging.jar:lib/eigenbase-xom.jar:lib/eigenbase-resgen.jar:lib/eigenbase-properties.jar:/usr/local/mysql/mysql-connector-java-5.0.5-bin.jar" \
     mondrian.test.loader.MondrianFoodMartLoader \
          -verbose -tables -data -indexes \
	       -jdbcDrivers=com.mysql.jdbc.Driver \
	            -inputFile=demo/FoodMartCreateData.sql \
		         -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"

For more detailed information, please refer to mondrian documentation : http://mondrian.pentaho.org/documentation/installation.php