I have created a cube in SQL 2000 SP4 Analysis Manager. I would like to ask
how can i schedule or automate the 'Process Cube' procedure in it?

Thanks.
Best Regards,
Andy

Don't think SQL 2000 supports this. In SQL 2005, you can create an XMLA
script to process the cube...

Chu

Andy wrote:

1st solution : You can create a DTS with an object "Analysis Services
Process task", and schedule it with SQL agent. It's the easier way, and
if you have just some dimension or cube to process, it's a good
solution.

2nd solution : you can create a program (VB, ...) using DSO (Microsoft
Decision Support Objects). It's really easy to use these objects and
process a cube. You can after schedule the excution of this program.
It's more powerfull, because you make what you need exactly (example :
read SQL table to find cube or dimension to process, ...).


Regards
Thierry

Andy wrote:

For AS2000, use "Parallel Process" provided with SQL Server 2000 Resource Kit.

For AS2005 I am still looking for the updated version of "Parallel Process".
AS2005 allows you to process partitions in parallel but only within one
single transaction. "Parallel Process" would not rollback the sucessfull
transactions. For me this is a big limitation from AS2005.

"baty" wrote: