The Baker's Dozen: 13 Tips for Querying OLAP Databases with MDX
MDX is a SQL-like query language used to retrieve data from OLAP databases and to define Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services.
by Kevin S. Goff
March 17, 2008
DX is just like Transact-SQL, right? MDX is English-like and therefore easy to learn, right? Different software tools offer MDX generators and therefore I don't need to learn MDX, right? MDX isn't that popular, right?
Well, just like the punch line of the old Hertz car rental commercial, "Not exactly." If your organization uses OLAP databases, you can add great value by knowing how to query OLAP databases using MDX queries. MDX is to OLAP databases as SQL queries are to relational databases. This article will cover common OLAP query requirements and MDX code solutions.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
DX is just like Transact-SQL, right? MDX is English-like and therefore easy to learn, right? Different software tools offer MDX generators and therefore I don't need to learn MDX, right? MDX isn't that popular, right?
