Microstrategy Interview Questions - part 11

  1. What types of flat files does the report cache on the MicroStrategy Intelligence Server 7.0 create? Are they accessible from other tools?
    • Report caches stored on disk on the MicroStrategy Intelligence Server 7.0 are in a preprocessed, proprietary format. Therefore, they are not accessible by means other than the MicroStrategy COM API. Datamarting is implemented in MicroStrategy Intelligence Server 7.1 to address this requirement. Element and Metadata Object caches only exist in memory and are not stored on disk, unlike Report caches.
  2. Can a SQL generation request be cached?
    • Yes, a SQL generation request can be cached. The next time the same report is run, the SQL is retrieved from the cache instead of being generate at the runtime.
  3. Is there a setting that can control the client side cache?
    • There are no exposed settings regarding the client side cache.
  4. Is there an expiration time for the different caches?
    • For the report cache default, the expiration time is 24 hours, but it is configurable up to 999,999 hours. For element cache and object cache there is no expiration time setting. The only ways of removing them are either purging the caches from the project configuration or restarting the MicroStrategy Intelligence Server.
  5. Will Cache files be created when Caching is turned off at the Project Configuration?
    • If the History List (Inbox) is enabled, cache files will still be created.