Afternoon,
I have a simple list report written against an FM package (Dynamic) - 4 dims and 1 fact. Report returns 200k rows of data ( yes i know its not very insightful, but stay with me). When run as a background job and to save as Excel its taking approximately 30 mins to generate the Excel file. Select statement runs and completes in about 30seconds
The same report written against a data module using the same dims and fact but using a data server as its access point. Returns the excel output in less than 2 minutes. Still not supersonic i know, but compared to the FM report its crazy. Its not caching as I have tested with different parameters and get a very similar result.
Anyone have any thoughts on why this could be happening?
Thanks