We are trying to determine the best performance strategy for BO pointing over SAP BW data. We want to know if there are any caching options available on the Webi Side on BO to cache the result set from the BEX query...Is a feature like this available on BO so that we can have good performance.
Most of the BEX queries take long to run and we have tuned them well. So we were wondering if anything is possible over the BO side to cache the queries.
Would really appreciate an answer here.