...
These resources have been invaluable to me. They should be enough to help you get from relying on jpivot, jrubik, etc to generate your queries to being able to formulate good queries, make modifications to them, add filtering, and other things to your queries that aren't straightforward in gui-driven analysis tools. The two tools together (gui tools + your own intellect) make a far more powerful team.
Posted on behalf of Phantal from the Pentaho Forums
More information and external links
...