Chapter 5. Optimizing Dimension and Cube Processing

In this chapter, we will cover:

  • Understanding dimension processing options
  • Learning about basic dimension processing
  • Learning advanced dimension processing options
  • Using out-of-line bindings for dimension processing
  • Dealing with partition processing options
  • Using SQL Server Integration Services to process Analysis Services objects
  • Monitoring and tuning processing performance

Introduction

This chapter discusses various processing options available with dimensions and cubes. As discussed in the previous chapters, all commands sent to Analysis Services use XMLA language—the same holds true for processing commands. You will start by learning the basic processing commands and work your way up to more complex ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.