how to schedule automatically processing cube or AS?

Hi,
My dataware house is changing daily.
How can I schedule automatically processing cube to reflect this change
if it is doable?
Thanks,
Guangming
Obviously you can write an application program to do it using the standard
DSO (AS2K) or AMO (AS2K5), but I assume you are looking for an easier way.
AS2K: DTS packages have an AS Processing Task -- create a package and
schedule it with SQL Agent. You can also process an object from VBScript and
execute it from the command-line.
AS2K5: IS packages have a similar capability, but you can also script out
the processing into an XMLA script and then execute it via the Execute AS
DDL task, or execute it directly in SQL Agent step (there is a new AS
Command type which is an XMLA script), or you can write an IS package which
takes the XMLA script from a file to execute it and then using dtexec.exe
you can execute the XMLA script from the command-line.
Lots of options. Hope that helps.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Word 2003 memory Leakage" <Word2003memoryLeakage@.discussions.microsoft.com >
wrote in message news:F5E98791-8D58-454A-9013-A2AC63C58259@.microsoft.com...
> Hi,
> My dataware house is changing daily.
> How can I schedule automatically processing cube to reflect this change
> if it is doable?
> Thanks,
> Guangming
|||Depending on your data structures AS2k5 also has its pro-active caching
feature. Keep in mind that this works best in situations where you can
identify the incremental changes. You can setup polling or notifications
so that AS can detect changes in the source data and the reprocess the
cubes itself.
Have a look in the AS2k5 BOL if you are interested as there are quite a
few settings you can adjust to control this feature.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|||thanks, seems several options there.
I will try.
BTW, what is AS2k5 BOL ?
"Darren Gosbell" wrote:

> Depending on your data structures AS2k5 also has its pro-active caching
> feature. Keep in mind that this works best in situations where you can
> identify the incremental changes. You can setup polling or notifications
> so that AS can detect changes in the source data and the reprocess the
> cubes itself.
> Have a look in the AS2k5 BOL if you are interested as there are quite a
> few settings you can adjust to control this feature.
> --
> Regards
> Darren Gosbell [MCSD]
> <dgosbell_at_yahoo_dot_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
|||
> BTW, what is AS2k5 BOL ?
Sorry, newsgroup slang for Books OnLine, (which is the help file). It is
my understanding that with the September CTP, the help is pretty close
to complete. There is even a separate download available for just the
latest help file. (note: the sept help is still titled as "June CTP" -
this is a known issue )
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell