Hi,

After I have updated my fact table or tables how should I update my
cube?

Should I manually right click on the cube and select the process now
option or is there a better way to go about this??? Ideally I would like
that the cube(s) and the dimensions should be automatically updated
(processed) after the underlying fact and dimension tables have been
updated. Can I automate this? Of yes, please guide how...

Thanks.

It can be automated using DTS.

public @ the domain below
www.tomchester.net

"Learner" <wantnospam (AT) email (DOT) com> wrote

It can also be automated through BATCH scripts (.bat).

Use Paralel Processing Utility - from command lines.

(here is where you download it:

http://www.microsoft.com/downloads/d...displaylang=en

Tom and Harsh,

Thanks for your replies.

Currently I do all of the following manually and kindly tell me if a DTS
alone can handle all of these automatically. Please guide me for each
step (if possible) because this can really make life easy for me:

1) I move certain tables from one database to another. Currently for
this part only I have saved a DTS and I run it manually


2) I delete all records from a table XYZ based on a SQL statement which
I run from Query Analyzer (Basically I do a delete all SQL)

3) I populate this XYZ table using a SQL statement which again I
manually enter and run from Query Analyzer

4) I do some linking of fields between XYZ table and another table -
again by manually entering and running an SQL statement from Query
Analyzer

Please guide how can I automate the above tasks.


Regards.

Look below .. don't know how you created the DTS ... if you saved the result
of the wizard you know need to open the package that you saved and do some
changes.

\Michael Vardinghus

Learner <wantnospam (AT) email (DOT) com> wrote

the DTS-script and choose Schedule)
MIVAR: The command that you fire away in Query analyzer can be put in an
execute SQL Statement in the DTS-package above (you need to connect step 1
with this step 2)
must be followed by this step 3...)

time only task ?