locked
Proactive caching RRS feed

  • Question

  • Hi, 

    I am trying to implement proactive caching to my cubes. I our stucture, we have a staging database that contain views reading from live tables from different servers. our cubes are linked to the staginf database (so they are reading data from views and not from tables). I did all the steps of proactive caching, but it is not working. Does proactive caching work on views ? is this related to SQL notifications when updates are done over the views ?

    Your help is appreciated

    Georges 

    Monday, March 30, 2015 6:44 AM

Answers

  • Hi JorjeR,

    According to your description, you find the proactive caching is not working. Right?

    In Analysis Services, the a simple ProactiveCaching object is composed of: timing specification, and table notification. The table notification defines the notification schema between the data table and the ProactiveCaching object. So it must be table. In this scenario, you query data from view(virtual table), so it can't be working.

    Reference:
    Proactive Caching (Partitions)

    Best Regards,

     


    Simon Hou
    TechNet Community Support


    Thursday, April 2, 2015 12:37 PM