MDX and response time in ProClarity and Excel 2007
I have hear some talk, from other consultants here in Sweden, about the MDX generated by Excel 2007, when querying SSAS 2005 cubes, is slow in some scenarios. The worst performance killers, from what I have been told are arbitraty shape queries and calculated members.
In this first blog post about client performance I will compare the MDX generated by ProClarity 6.3 and Excel 2007 (sp1) in two other scenarios.
It will help with finding a baseline of each clients performance under one standard scenario and one that is more extreme.Read more...