I'm interested in this one, too. Currently, we are modeling our cubes as Star schemas in Erwin, showing the cube as a Fact table with a series of Parent/Child mapping tables for the dimensional hierarchy.
The approach leaves much to be desired, but handles valid values, CRUD, and metadata requirements.