Designing Operational Scripts for a Multidimensional Database Solution
There are multiple approaches to the automation of Microsoft SQL Server Analysis Services administrative tasks. Microsoft SQL Server Integration Services contains a powerful set of tools that can be used to automate such tasks. For more information, see Processing Objects Using Integration Services.
The following topics explain the various aspects of managing an instance of Analysis Services:
Discusses techniques that can be used to perform administrative tasks.
Covers automated execution of DDL scripts, cube and mining model processing tasks, and data mining query tasks.
Shows how to create, alter or delete Analysis Services objects using scripts.
Discusses the ways in which you can arrange for automated running of jobs to accomplish administrative tasks.