We have a simple MDX returning 16 000 rows. When I look at the execution time in SQL Profiler, the MDX Query Begin to MDX Query End takes 1 second. But from starting execution of the MDX until til result is displayed in management studio, the
total time is 4 second. So it seems that managements studio is taking 3 seconds to display the result. Is there any explanation for this?
The same happens when running the MDX from openquery on the SQL server.
When connecting to the cube from excel, returing the same result, the execution or render time seems much faster.
That can be correct. SSAS sends a resultset consiting of XML to the client after it has finished the processing. It is probably the rendering time in MMS that adds more seconds. 16 000 rows is quite a large resultset.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.