Does anybody know how I can automatically & incrementally
update a cube on a daily basis?

Manually, I can do it in Analysis Manager by either using a
filter or by using a separate fact table (containing only the new
rows for a fact table). And with partitions, I can additionally
use data slices.

To automate things, I can create a DTS package, using
an "Analysis Services Processing Task". However with that
task I can choose just one predefined object (db, or cube,
or partition, or dimension...). Question: how can I pass an
argument into an "Analysis Services Task" so that, if my
DTS package runs every night at 1 AM 02-DEC-03, only
rows from yesterday (01-DEC-03) will have been
processed?

I believe running the incremental process would accomplish this, that can be
scheduled in DTS.

--
Ray Higdon MCSE, MCDBA, CCNA
---
"ivo" <ivo (AT) ivo (DOT) net> wrote

"Ray Higdon" <rayhigdon (AT) higdonconsulting (DOT) com> wrote


Thanks Ray.

Yes but I have partitions as well. If I parameterize
one partition for incremental update (through "AS
Processing Task"), I can run that task for one month
only. On 1st of next month, I can forget that task,
and I have to create a new task for the next monthly
partition.