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