Environment: SAP BO Design Studio 1.6, SAP BW 7.3 and Design Studio dashboards hosted on Netweaver Platform Enteprise Portal.
We have developed a dashboard with couple of Bex queries. The cache (cache mode 5: Query Aggregates) has been enabled for these queries in BW. In order to test caching, we followed below steps -
1. At the start of the day, refreshed the Bex queries using RSRT transaction to ensure cache is filled.
2. Refreshed the bex queries subsequently using RSRT transaction and monitored the execution through SM50 where in it was noticed that it is fetching results from cache.
3. Executed the dashboard that internally triggered execution of the same queries and monitored the execution through SM50 where in it was noticed that the queries ignored the cached and went for sequential read from tables.
This is confusing me as queries when executed through RSRT are fetching results from cache but post that when same queries are executed from Design Studio dashboard they ignore the cache and go for sequential read from table.
Note: Bex queries do not have any variables and provide a snapshot of data.
Thanks & Regards,