How to use Pentaho Data Integration (Spoon 4.4) for Star Modeling

Question

I'm looking for a tool to build a Mondrian's cube XML description file to use over my Star Schema (one fact table and 4 dimensions tables directly link to the fact table).

I'm a bit lost, browsing tutorial doesn't help since they seem to be about another version than mine. Mine doesn't include the Star Model perspective, I just have a Model perspective.

My feeling is that this Model perspective is just useful to build Mondrian cube for a flat model (with just one big fact table). I would be glad if someone could confirm that. But my main demand is : how to build a Star Model description schema (with Pentaho's tool) ? If there's a missing plugin, how to install it ?

score 1 · Accepted Answer · answered Dec 31 '12 at 09:26

1

You need to download a separate tool for the moment called schema workbench. Get it from the mondrian not pentaho project on SourceForge.

This tool will be replaced by something new in the next 6 months but it does what you need and has handy validation built in

answered Dec 31 '12 at 09:26

Codek

5,114
3
24
38

Ugly but effective tool ! Thank you ! – AsTeR Jan 03 '13 at 21:00
yup! but with the validation it provides and most of the functionality I think it's better than hand crafting a mondrian xml schema! – Codek Jan 04 '13 at 07:38
I agree but the UI library used put my computer back to 1996 ;) – AsTeR Jan 04 '13 at 08:36

How to use Pentaho Data Integration (Spoon 4.4) for Star Modeling

1 Answers1