Physical Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 267

Defining Partitions in Analysis Services
We show next how MOLAP, ROLAP, and HOLAP partitions over measure
groups can be defined in Analysis Services.
Fig. 7.14 Initial partition for the Sales measure group
Fig. 7.15 Template query that defines a partition
Figure 7.14 shows a unique initial partition for the Sales measure group in a
data cube created from the Northwind cube. As we can see, this is a MOLAP
partition. Assume now that, for eciency reasons, we want to partition this
measure group by year. Since in the Northwind data warehouse we have
data from 1996, 1997, and 1998, we will create one partition for each year.
We decided that the first and the last ones will be MOLAP partitions, and
the middle one, a ROLAP partition. To define the limits for the partitions,
the Analysis Services cube wizard creates an SQL query template, shown in
Fig. 7.15 ,whichmustbecompletedinthe WHERE clause with the key range
corresponding to each partition. In order to obtain the first and last keys for