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