Hi,

I am trying to get proactive caching working on my MOLAP partition. It works
fine when I have ForceRebuildInterval. But if I set it to "Update when data
changes" silence interval of 10 sec. with SilenceOverride interval of 10
minutes and set up a polling query, it doesn't work. Here are my settings:
"Update when data changes"
10 seconds
10 Minute

On the notification tab
Enable Incremental updates = true
Polling Query = SELECT MAX(ID) FROM FactTable WHERE Date=20061010
Processing Query = SELECT * FROM FactTable WHERE Date = 20061010 AND ID
BETWEEN ISNULL(?,0) AND ?
Table = FactTable

I can see in the profiler that Proactive caching events do fire but my
partition doesn't get refreshed. What am I doing wrong?

The Profiler events should show some indication of what is going wrong --
I.e. is processing starting? is an error being raised? etc.

Thanks,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Mukesh Kumar" <MukeshKumar (AT) discussions (DOT) microsoft.com> wrote