query run: takes ages to execute!
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