Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Proactive Cache Expand / Collapse
Author
Message
Posted Sunday, June 23, 2013 11:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 11:26 PM
Points: 116, Visits: 397
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

Thanks
Sanjeewan
Post #1466577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse