This seminar provides comprehensive coverage of SSAS storage options and optimization

techniques. It also explores ways to partition measure groups to improve processing

and query performance and describes ways to design and optimize cube aggregations.

In a typical SSAS enterprise environment, three groups of people are involved in the

different phases of the SSAS cube’s life cycle. Database developers focus on designing and

programming the cube. Administrators are concerned with managing the cube. And end

users query the cube and run reports.

As an SSAS administrator, you will perform various management tasks in different phases

of the cube life cycle. Two ongoing activities that you need to master are deploying and

processing SSAS objects.

Seminar objectives:

Implement storage design in a cube.

Deploy SSAS databases and objects.

Implement processing options.

Step 1: Defining Measure Group Partitions and Aggregations

Understanding Partitions

Creating Measure Group Partitions

Contents xiii

Selecting Partition Storage Modes

Understanding Proactive Caching

Understanding Aggregations

Defining Aggregations with the Aggregation Design Wizard

Practice: Defining Measure Group Partitions and Storage

Step 2: Deploying SSAS Objects

Deploying SSAS Projects with BIDS

Using the Deployment Wizard

Running XMLA Scripts for Deployment

Using the Synchronize Database Wizard

Practice: Deploying SSAS Objects

Step 3: Processing SSAS Objects

Understanding SSAS Processing Options

Processing SSAS Objects in BIDS

Processing SSAS Objects in SSMS

Setting Advanced Processing Options with Proactive Caching

Using the Analysis Services Tasks in SSIS

Practice: Processing SSAS Objects

Case Scenario: Implementing Low-Latency OLAP and

Deployment Strategies

This seminars series based on Microsoft Certification Training Kit for

Exam 70-448: Microsoft SQL Server 2008 - Business Intelligence Development and

Maintenance

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)