A Report based on a multiprovider A is taking 9 min to execute. The Multiprovider is based on InfoCube B and InfoCube C and and Info object D. So, I created aggregates on both the cubes B & C.
Though the 'valuation' of aggregates is + and ++++ respectively for two cubes AND the 'Usage' increase by 1 each time I execute the Report, BUT still it takes me 8.35 min to execute the report.
Do the aggregates of cubes not function properly for the MutiProvider above. Please suggest what can be done to improve its performace as the report times out in the Live m/c.
Many thanks for your help,