Databases Reference
In-Depth Information
Figure 12-15
10. You will be in the final page of the Partition Wizard. Select Design
aggregations later, Process Now and then click Finish. The partition
will be processed and you can browse the cube data.
The number of partitions for a specific cube can typically increases over time.
Users might not be browsing historical data with the same granularity as that
of the recent data. For example, you might be more interested in comparing
Sales data for the current month to that of the previous month rather than
data from five years ago. However, you might want to compare year-over-
year data for several years. By merging the partition data you can see some
benefits during query performance. You learn the considerations you should
take into account to merge partitions in
Chapter 13
.
There are two main requirements to merge partitions: the partitions should be
of the same storage type, and they need to be on the same Analysis Services
instance. Therefore if you have remote partitions, they can be merged togeth-
er only if they are on the same Analysis Services instance. To merge parti-
tions, do the following:
Search WWH ::
Custom Search