January 12, 2007 at 4:05 pm
I am experiencing very slow performance when running Olap queries in Excel 2003. The cube contains 13 dimensions and 4 measures. When designing storage the system creates 40 aggregrations. The cube size is relatively small. I have tried changing storage design but cannot see any improvements in performance. Does anyone have any suggestions?
January 15, 2007 at 8:00 am
This was removed by the editor as SPAM
January 15, 2007 at 9:13 am
Try to run a SQL Profiler trace on Analysis Services when you refresh the Excel 2003 pivot and look at the MDX query then try to use a native Excel 2007 version of the same pivot and look at the difference in term of both speed and MDX query generated by Excel. The difference is simply enormous. What takes 1 hour with Excel 2003 takes only a few milliseconds in Excel 2007.
I know that it is not obvious to switch to 2007 like that and I am feeling myself the frustration. I will have to wait at least 1-2 year(s) before my employer will even consider upgrading despite the HUGE productivity boost 2007 will bring.
Believe me, I tried all possible cube fine tuning and best practices, Excel 2003 do not care and generates sub-optimal MDX leading to poor performance whatever you do to your cube.
Philippe
BI Guy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply