Nick Goodman, director of BI solutions at Pentaho, has posted a short tutorial explaining how to run MDX queries in Mondrian (the open source OLAP engine) here:
I’m going to spend some time looking at Mondrian’s implementation of MDX in the near future, which I’m looking forward to; it’ll be interesting to see how it differs from AS MDX (if at all).