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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.