How to automatically refresh sql server olap cube

Graeme picture Graeme · Jan 25, 2010 · Viewed 12.2k times · Source

I have built a cube in visual studio and deployed to SSAS. How can I get the data refreshed using a nightly sql batch job or some other means? TIA

Answer

Rob Farley picture Rob Farley · Jan 25, 2010

A few options:

  1. Put a Process Analysis Services task in an SSIS package, and schedule the package with SQL Agent (great if you already have an etl package).
  2. Using SSMS, go to the Process dialog box but hit "Script" at the start to get the XMLA command. Then put this in a SQL Agent job.