Hi everyone,
I have a report with three row expansion and use a single EvDRE. Number of rows at a given time is less than 100 and row expansion is there. There is only a multiplication formula (excel one on cells in row) and then spreadout to 12 columns evenly.
When I perform Expand All, EvDRE takes 2-3 minutes to execute. Please suggest how I can improve the retrieval performance of this report. I have done optmization of the cube - No perceptible difference. Removed all formatting - No improvement.
Please suggest me what can be the possible issue.
Regards,
Ben Ramos