Hi Experts,
I have a workbooks with four queries running for business managers and this wookbook is on portal now.
I order to improve the performance of the portal, I have created IB jobs to store cachein the system.
Now the problem is cache is only working for individual business manager and not working for all managers.
There is a hierarchy on business managers (about 40), so different IB jobs can be set up for both of individual managers and totals.
The workbook has a big structure with defined cells (about 3mb).
It takes less than 2 mins to run this wookbook for individual managers in analyzer and portal.
It takes about 7 mins to run for all managers in analyzer and Information Broadcaster and it takes about 18 mins to run for all managers in Portal.
I tried to run trasaction "sm51" to check the process, it is "CL_RSR_REQ" under report column.
The portal performance for all managers is required to be reduced to below 2 mins.
Please let me know if you need more information.