Report refreshing for long time
I have a record count of 45,000 . I followed the best practices to create the universe and report( Webi Report) .But still my report is taking 45 seconds. Please let me know how to optimize the time , the report runs.
All my users want report less than 7 seconds.
Even I changed the settings in the universe designer:
Limit the size of result set to 50.000.
Looking forward for your inputs.