Hi, I have an MDX query which runs fine in the MDX Sample Application. It runs against an SSAS 2000 cube. In my query there is a recursion kind of a logic. It takes about 1-2 sec to run in the MDX Sample Application. My sample application is in the same server as my AS 2000 cube is. However when I run the same MDX from another server through BIDS (2008) it takes an unusually long amount of time to run. Most of the time it times out. :( As a workaround I created 4 calculated members in my Cube itself (Initially these were used as members in my MDX). I thought that maybe the recursion logic is the culprit so I modified my MDX, removed the recursion part. But still from my SSRS it is taking a long time. Any pointers to where I am missing the trick ? Thanks in advance, Suman

Hi Suman, I have got a simlar problem and just asked a question http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/50dd30a8-880c-4124-978d-5054f64abf55 . In my case I am only returning 300 rows and still goes very slow. The only area i am suspecting is the SSRS datasource component. Hopefull someone must have had this problem before. Regards visaade

Hi Guys, Any Pointers to the above issue please.

Seems you need to add SET FMTONLY OFF to your query. Check this thread http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/d46a859f-8635-4ff7-b006-e52ce58252a6/ Regards 'Dotun

The SET FMTONLY OFF worked for me and report is now very fast.