Post reply

HI amit gupta

  • October 12, 2010 at 11:21 pm

    #227834

    hi dear friend.thanks for hole your help very much.

    I use proactive caching property :select Automatic MOLAP with default options:silence interval:10sec and silent override interval:10min.

    cube detected changes but for seeing these changes in BROWES,need to process cube manually or with using jobs in ssms,becouse proactive chaching

    don't this.What options are selected till process cube while changes become,and dosen't need to process manually.

  • October 13, 2010 at 2:15 am

    #1236021

    Hi Elham,

    Proactive caching detects the changes and then process the cube automatically. If it is just for detecting changes then feature will not be useful.

    Let me take your example, if any database changes happens then it will wait for 10 seconds and it will start reprocessing cube. I have tested this on my machine and i am attaching screen shot of SQL Server profiler.

    Thanks,
    Amit G
    http://www.msbiconcepts.com

  • October 13, 2010 at 3:18 am

    #1236047

    This post triggered me to write new post on my blog :)... Please find link to the post below:

    http://www.msbiconcepts.com/2010/10/proactive-caching-sql-server-2008.html

    Thanks,
    Amit G
    http://www.msbiconcepts.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply