How to automate cube generation

#1

How can I automate a cube generation? is it possible to
schedule a job on the SQL Server Agent?
Thanks

#2

Hi Jorge,
You should use one DTS package but you have to analyse your kind of
load(full , incremental o update). After that you can schedule with SQL
Server Agent

"Jorge Garzon" <jorgega75 (AT) hotmail (DOT) com> wrote

Quote:

How can I automate a cube generation? is it possible to
schedule a job on the SQL Server Agent?
Thanks

#3

Are you talking about cube loads or actually creating the cubes? You can
automate cube creation via the DSO model (Decision Support Objects). It's
kind of like the DMO model for SQL Server.

"claudio" <claudio.lucio (AT) coresynesis (DOT) com.br> wrote

Quote:

Hi Jorge,
You should use one DTS package but you have to analyse your kind of
load(full , incremental o update). After that you can schedule with SQL
Server Agent

"Jorge Garzon" <jorgega75 (AT) hotmail (DOT) com> wrote in message
news:008b01c37712$f38a0010$a601280a (AT) phx (DOT) gbl...
How can I automate a cube generation? is it possible to
schedule a job on the SQL Server Agent?
Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to automate cube generation

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How to automate cube generation - 09-09-2003 , 03:42 PM

Re: How to automate cube generation - 09-09-2003 , 04:36 PM

Re: How to automate cube generation - 09-09-2003 , 09:41 PM