Export (0) Print
Expand All

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:

Topic

Description

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.

Community Additions

ADD
Show:
© 2014 Microsoft