Chapter 14. Managing Partitions and Database Processing

In this chapter, you will learn how to:

  • Configure a dimension to use ROLAP or MOLAP storage.

  • Configure a measure group partition to use ROLAP, HOLAP, or MOLAP storage.

  • Configure rigid attribute relationships.

  • Process a dimension using the Process Update processing option.

  • Process a partition using the Process Incremental processing option.

  • Configure proactive caching.

  • Create, merge, and manage measure group partitions.

  • Import an Analysis Services design into a Business Intelligence Development Studio project.

In Chapter 11, you learned how to use client tools and MDX queries to get data out of Analysis Services and into a PivotTable dynamic view or other report. In order to get data out of the Analysis ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.