Skip to Content
0
Former Member
Sep 07, 2007 at 12:29 AM

Report hitting ODS is getting timed out

14 Views

Hi, Please check the below data flow and let me know the solution:

I have a report on Multi Provider which inturn has only one DSO related to CRM; In the context menu of DSO, I have not checked SID creation automatically and I do not have any indexes. This is all about ODS.

When coming to report; USERS want to see 10,000+ records/rows in the output, when I run the report it is taking long time and finally getting timed out. Please let me know the possible solutions to get the 10,000+ records/rows in the output.

Thanks in advance