Hi there,

Only recently I started to dabble in Analysis Services, and I notice I
can refresh cubes. What I wish is to daily automatically refresh a cube.
Can this be done? Sofar I have not found anything about scheduling a job
for that purpose in BOL.

Tnx,

Hans Brouwer

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

You could write a DTS package to refresh the cube by schedule

Create a DTS package and schedule it. Alternatively, you
can write custom code and schedule it. Let me know if you
need code samples (DTS as well as custom)

Abhinav Kumar
akumar (AT) itmag (DOT) com.au

If it's possible please show me some example of DTS
Thank you very much .

Ovidiu


"Abhimnav Kumar" <akumar (AT) itmag (DOT) com.au> wrote

Hi Hans,
SQL Server DTS is the place to go to create and schedule a job that will
automatically refresh your cubes. Analysis Services does not have an
automatic processing function.
CB

"hansje" <hansjes (AT) anonymous (DOT) com> wrote