I'm interessed by proactive caching into SS2K5.
I saw : http://msdn2.microsoft.com/en-us/library/ms175646.aspx
I would like more detail on the underlying mecanism in term of query into
the relational database (what are criteria ? does it sends simply a query
each sec, min or hours) ... for medium latency or automatic olap.

thanks and regards,

Renaud Harduin
Paris

Hi Renaud,


This TechNet paper discusses some details of the proactive caching
mechanisms - the Appendix explains custom settings and gives an example
of a relational polling query:

http://www.microsoft.com/technet/pro.../rtbissas.mspx
Real-time Business Intelligence Using Analysis Services

Published: April 1, 2005
By Paul Sanders
...
Appendix

This appendix provides additional details of the proactive caching
settings, and the use of polling queries and incremental processing
queries to incrementally refresh a cube using proactive caching.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***