Dynamic Cube partitioing in MSAS2000

Hi,

Pl give me a way, by which i can dynamically make the cube's partitions. Actully every month on start i have to create a partition for that month manully. Can it make it automatic by any way?

Pl help me for this regard i need it urgently.

Thank and Regards

Abhishek

SQL Server Integration Services has a Analysis Services Execute DDL task which can be used to create partitions. The DDL for this task can be created by a script task which takes a template DDL and inserts the month specific information such as the partition name and ID and it's source table. You can then use the Analysis Services Processing Task to process those partitions. These tasks can be part of a scheduled SSIS package.

|||

Hi Matt,

Thanks for your response, But i am working in MS AS 2000. Pl help me for SQL Server 2000 reference.

Regards

Abhishek

|||Sorry, I missed that. Analysis Services 2000 can work with SQL Server Data Transformation Services in a similar fashion. You'll want to create a script task and use DSO to create the partitions and then yo can use the AS Processing task to process it.|||

Hi Carroll,

Thanks a lot to give me a way as DSO. It will be helpful for me if you send some demo code of "how to use it" and specially, how to use it using 'DTS'.

Regards

Abhishek