When Not To Write MDX and When Not To Use Analysis Services
MDX is a great way to achieve some objectives easily and efficiently. However, there are some things better done in other ways. I will first discuss three distinct mistakes, which designers and developers tend to make when working on a typical BI solution.
1. Leaf-Level Calculations
Read more...