MS SQL Data Warehousing - how to schedule automatically processing cube or AS?

Author

how to schedule automatically processing cube or AS?

Word 2003 memory Leakage

2005-10-17, 1:24 pm

Hi,

My dataware house is changing daily.

How can I schedule automatically processing cube to reflect this change
if it is doable?

Thanks,

Guangming

Dave Wickert [MSFT]

2005-10-17, 1:24 pm

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" < Word2003memoryLeakag
e@discussions.microsoft.com>
wrote in message news:F5E98791-8D58-454A-9013- A2AC63C58259@microso
ft.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

Darren Gosbell

2005-10-17, 1:24 pm

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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Word 2003 memory Leakage

2005-10-17, 1:24 pm

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_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>

Darren Gosbell

2005-10-17, 1:24 pm

> 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Sponsored Links