Performance Issuee : BO Report Using 7 Different BEx Queries
I am facing a problem with a BO Report regarding its performance issues.
Its a report being presented to High level of Managers hence it need to run n refresh in shortest possible time.
Could you please suggest some techniques to optimize the queries used in BO Reports.
1 BO Report
- 7 Queries
- 4 Multiproviders
- All Compressed & Aggregated.
I think precalculated data retrieval might help but I seek advice on this before proceeding.