Skip to Content
0
Former Member
Mar 09, 2009 at 07:57 PM

Problem with query performance

24 Views

Hi All,

While loading data if we run the report, will it make any difference in the query performance? I have a cube with 230 million records I am running the delta which has got another 230 million records. Now I am trying to run the queries on the cube, all those timed out.

But I have a DSO with the 480 million the same queries are running good on the DSO. But I wanted to run the reports on the cube not on DSO what can I do? Is the data load giving any problem in the query runtime??

Pleas advise me what to do?

Regards

Kiran