Database Reference
In-Depth Information
Figure 12-12.
Configuring the partitioned data storage location
■
Another technique used with partition folders is to spread them across multiple hard drives using a RAId
array. A RAId array increases performance implicitly without the administrative overhead of defining partition
locations explicitly.
Tip
After you have identified the location of your partition's folder, you can click Next, which takes you to the
Completing the Wizard window. On this screen, you are given the option to name your partition. In Figure
12-13
,
we have named ours
Fact Sales Older than 1994
.
In this window, you can also design your aggregations immediately or delay them. Designing aggregations
involves determining which totals and subtotals to include within the cube partition.
The radio button default setting is “Design aggregations for the partition now.” Keeping the default setting
and clicking Finish starts the Aggregation Design Wizard.
If you check the “Design aggregations later” radio button (Figure
12-13
), you can launch the Aggregation
Wizard from the cube designer's Aggregations tab at a later point in time. This option is often a good choice,
because it allows you to return later to create all your cube partitions at one time.
