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.

In This Section

The following topics explain the various aspects of managing an instance of Analysis Services:



Managing Analysis Services using Programming

Discusses techniques that can be used to perform administrative tasks.

Processing Objects Using Integration Services

Covers automated execution of DDL scripts, cube and mining model processing tasks, and data mining query tasks.

Scripting Objects Using SQL Server Management Studio

Shows how to create, alter or delete Analysis Services objects using scripts.

Scheduling Administrative Tasks Using SQL Server Agent

Discusses the ways in which you can arrange for automated running of jobs to accomplish administrative tasks.