• Chris Webb has written on this (and you can find similar articles through Google):

    Build Your Own Analysis Services Cache-Warmer in Integration Services[/url]

    Building a Better Cache-Warmer, Part 2: The Formula Engine Cache[/url]

    Pro-active caching has not really something to do with cache warming.

    It is used when your SSAS cube uses ROLAP instead of MOLAP but you want some performance boost.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP