Will MicroStrategy 8 help improve my SAP BW performance?
Yes. MicroStrategy utilizes a sophisticated caching architecture to store results for frequently accessed queries. This ensures that these results are retrieved for the user from the MicroStrategy Intelligence Server without re-execution against SAP BW. In addition to MicroStrategy OLAP services, users can drill within the cache for further OLAP analysis. Scheduling of these caches during non-peak hours improves performance.