query run: takes ages to execute!

[Former Member]

Hi,

I had created a query ( on cube which has roughly 497000 records ).

when i am trying to execute it, a pop up message will comes up after half an hour so saying that result has exceeded xxxxxx rows: and then after a while a affirmation of result is incomplete!

even after these two messages it never has given any out put! it is still running!

what could be done to see the results of the query?

I had removed all the chars in rows area except one and placed in free char area!

But the issue remains an issue

Any suggestions?

Thanks,

Ravi

[Former Member]

1. Run your query in RSRT with execute and Debug option

2. Check Display SQL Query in Database tab.

3. View your result and you will know which aggregates / tables its using and their selection.

4. Based on the SQL result you can fine tune your selection.

5. Try to run your selection with small range.

Hope this helps...