How do I dynamically increment OLAP cube in SQL server ?

[niraj2000]

I have created a cube in using Analysis Manager in Sql Server 2000. As the database grows, I want the cube to update itself. This can be done manually. But I want to automate for reporting capabilities.

Is anyone aware of such a facility in Analysis Manager of Sql Server 2002 for auto updates ?

 

[pabloj]

You can use DTS to:
1. extract from cube some key that tells you the last loaded record (or anyway store this info at loading time)
2. load more recent records into cube with an incremental update setting the WHERE key > lastinsertedkeyfoundat1
Stick to your guns

 

[MDXer]

I would (and currently am) write a vb app using DSO to do the incremental update. It is my experience that the DTS cube function are slow and have a large amount of overhead.

Paul