Believe it or not, Pentaho is what we have in place right now. For the ETL backend, I think it is a really nice tool. Flexible, intuitive, and measures up wel

Believe it or not, Pentaho is what we have in place right now. For the ETL backend, I think it is a really nice tool. Flexible, intuitive, and measures up well to Informatica and other $$$ tools. But the reporting model, with the designer/xaction dev/publish quirkiness just bugs me. I find myself editing the XML definition files when I want to change stuff rather than firing up the tools. The documentation is a little lacking as well, but I have demanding standards there. I also don't particularly care for how business models show up in the GUI for user-driven report building. To be fair, that is probably somewhat related to a poor model without proper dimensional design put in place. First pass efforts (before my time here) basically copied the operational system schemas into the data warehouse (shudder).