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

each period, a query such as the following one must be addressed to the data
warehouse:
SELECT MIN(TimeKey), MAX(TimeKey)
FROM Time
WHERE Date > = ' 1997-01-01 ' AND Date < = ' 1997-12-31 '
The values obtained from this query can then be entered in the wizard for
defining the partition for 1997.
Figure 7.16 shows the three final partitions of the measure group Sales .
Note that in that figure the second partition is highlighted. Figure 7.17 shows
the properties of such partition, in particular the ROLAP storage mode. This
dialog box also can be used to change the storage mode.
Fig. 7.16 Final partitions for the Sales measure group
Fig. 7.17 Storage mode for the Sales 1997 partition