MDX = ETL + OLAP on steroids
Much of my day-to-day involves putting together solutions that do a bit of data extraction, transformation and loading somewhere else (That’s the ETL bit). So that’s the transactional bit, at then end of the production line, once we’ve speont all this time, money and effort loading and validating this info you then need to quantify and carry out analysis on the metrics derived from this data…this is the OLAP.
With the imminent release of Microsoft SQL Server 2008 comes MDX or Multi Dimensional eXpressions. This article on ElReg does a better job of explaining than I ever would but I’m actually quite keen to get a better understanding of the ‘closing the loop’ power of the expressions language as increasingly our systems become ‘touchless’ and business processes need to be able to be run with minimal/zero intervention this sort of business intelligence becomes invaluable.