...
If you have problems with this stuff, check the forums other other wiki article, but suffice it to say, if you want to use the foodmart database to learn MDX, you'll want to get the above working before you go on.
Next, visit http://www.databasejournal.com/featu...le.php/1495511. this article. There are 63 different articles (at the time of this post) on writing MDX queries. Don't let the fact these articles are written for Microsoft's OLAP implementation scare you. Almost all the queries work fine in Mondrian -- in fact, if you look closely in the documentation on MDX, Julian (or whomever maintains that page) links to this set of articles as well. If there are any incompatibilities it typically takes a minor tweak to fix it. Just skip all the sections related to using their analysis tool(s), and copy or type up the queries yourself in jpivot, jrubik, or what-have-you.
Finally, on the topic of dimensional modeling concepts, take a peak at these two URLs, both should come in handy:
...
- abstracts/sg247138.html?Open
- http://msdn2.microsoft.com/en-us/library/aa299232(SQL.80).aspx
- SQL Server 2005 Analysis Services
- SQL Server 2008 Analysis Services
Again, on the last linklinks, ignore the fact itthat they's for a microsoft productre for Microsoft products. The things they say about MDX & and so-forth fall right in line with Mondrian on almost every point, enough so that if you're trying to wrap your head around how MDX works, its purpose, and all that, you should find very few differences between Mondrian and MS's implementation of OLAP.
...