Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Proactive Cache Expand / Collapse
Posted Sunday, June 23, 2013 11:18 PM


Group: General Forum Members
Last Login: Tuesday, March 3, 2015 8:22 PM
Points: 116, Visits: 399
Hi all,
I have problem regarding proactive cache
1.I have implemented a proactive cache in my cube .
1.1 Silence interval 1 min
1.2 Silence overirride interval 1 hour

Force rebuild interval 1 day

and incrmental queries

its doing all the things fine but problem is here Let say Empid - 1 , Salary -1000 when some one update the Emp source table for emp id- 1 and salary 1200 then ideally it should be 1200 . but cube is showing 2200.

so question is how to override cube cache

Post #1466577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse