Untangling MDX

I’ve been messing with SQL Server’s Analysis Services and have spent my first couple of weeks at Nuconomy working on an MDX DOM. MDX, or Multidimensionl Expressions, is the query language for OLAP databases and looks like SQL. I say looks like, because for someone who’s used to standard, relational SQL (that is, me), it’s extremely confusing, given the fact that a lot of it means things that are quite different from SQL….

You can read the copy of the original post, or if that goes down too, you can try the Wayback Machine’s copy of it.

Context: This post was automatically imported from my old blog, which was originally hosted on Microsoft’s ASP.NET Community Blogs. When they shut it down, I dumped all of my old posts to Wordpress. You can still check out the original blog on the Wayback Machine.