report debugging question

[tupac_rd]

Hi,

I have a report which was developed in Jun of 2008, and looks like it was running fine till recently, but now even though there is no code change, the report does not finish running even after 2 days. So I need to debug what is taking such a long time. Is there a best practice approach to figure out what query is taking a long time etc.,

Thanks
2pac

[rockytopmark]

Tools menu, Show Generated SQL/MDX

Copy the Native SQL for the object in the report and paste in a query editor for your RDBMS and try to work with it to determine which part(s) are the problem, be eliminating a piece at a time, until it runs fast.