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
+1
A:
A few options:
- 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).
- 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.
Rob Farley
2010-01-25 08:55:25
Looks like I didn't install part of SSMS as I don't have option to connect to AS. Got it in VS though, but it doesn't have an option to get the script on the process dialog box.We actually had it setup to do a full process but it looks like I have to process each dimension first, otherwise it fails.
Graeme
2010-01-25 13:29:45
Graeme - you only need to process the dimensions that have changed. If processing them all really slows down the job then you can test to see which dimensions have had changes and only process those.
ajdams
2010-01-26 14:12:11