Question: why use mdx instead of sql?
Answer: Because SQL was designed to handle only two-dimensional tabular data, the terms "column" and "row" have meaning in SQL syntax. MDX, in comparison, can process one, two, three, or more dimensions in queries. Because multiple dimensions can be used in MDX, each dimension is referred to as an axis.