Tutorial video for Kettle and Mondrian
There’s a nice video which shows how you can use Kettle together with the Mondrian Schema Workbench to populate a star schema and build cubes on top of it.
See “Pentaho Data Integration and Schema Workbench Tutorial” on the Pentaho web site (registration required).