O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required