Data Modeling Tool

Hi,

Can anyone recommend a data modeling tool that does effective dimensional modeling? It's probably wishful thinking but it would be wonderful if there was something out there that we could use to reverse-engineer our production BW system.

Thanks

Kevin