Implement Proactive Caching

Question

Hi All,

I would like to ask for your help since I'm new to SSAS.

I have created a cube for SQL Server 2008 R2 Standard Edition and found out that Proactive Caching is not supported.

I need to update the data every 30 minutes.

Please advise on how to implement Proactive Caching feature using other means.

Thanks,

Charllemagne

Answer 1

Hi All,

I managed to find this site and it's working.

http://www.bidn.com/blogs/timmurphy/ssas/1414/use-sql-server-agent-to-process-cube

Regards,

Charllemagne