tsohtan


Hi

Currentyl after i transfer the data from another database(source) to datawarehouse. I need to click on the "process" button in order to see the latest result. Do it have a command or way to do it programmatically or using the SSIS to do it

Anyone please point me the link for me to do the automate process

Thanks in advance for anyone provide me some clue.




Re: AUTOMATE PROCESS

Darren Gosbell


There are plenty of different options

  • SSIS has an SSAS processing task.
  • You could script the processing from SSMS as an XML/A command and schedule it from SQL Agent or using the ascmd sample that was released with SP2.
  • You could write a .Net app using the AMO to initiate the processing.







Re: AUTOMATE PROCESS

tsohtan

Hi Darren,

You again Smile . And thank again for the pointing.

And i found more details explaination on this,

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=230156&SiteID=1

Just provide for those are interested. And is worked and simple.

Thanks






Re: AUTOMATE PROCESS

Darren Gosbell

Yep me again . That's exactly what I had in mind.