December 22, 2008 at 6:44 am
Hi,
I have a cube and it is working fine with SQL 2005 Analysis Services Browser.But when i use this cube with SSRS it is taking long time to execute.For the cube,in SQL 2005 Analysis Services Browser, i am getting the result in seconds,but in SSRS to display the same results approximately it is taking 5-10 mins.
Do i need to set any options (like cache ) in SSRS? If so,how to do that ?
any help is much appreciated ...
Thanks in advance.
December 22, 2008 at 7:06 am
Analysis Services will cache data automatically in most cases. If you are having performance issues with just one tool, it is most likely that the tool is generating inefficient MDX.
Make sure this is the case by tracing the SSAS server while running the "same" query with both tools to see the differences. SSAS query performance can be impacted by a lot of different factors.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply