Description of the illustration select_partitions.gif
This screen capture shows the Partitioning subpage of the property sheet for the Units Cube cube. At the top of the property sheet are the tabs General, Aggregation, Partitioning, Storage, and Materialized Views.
The Partitioning subpages has the Partition Cube option, which is selected. The subpage has the tabs Select Partitions and Partition Member Analysis. Select Partitions subpage is selected.
On the Select Partitions subpage is the text, "Select one dimension and one or more levels to use for partitioning. Each dimension member at the selected level is stored in a separate partition with its descendants. Click Help for more information." From the Dimension list, Time is selected. The Aggregation Hierarchies lists display the hierarchies and levels for the Time dimension. The hierarchies are Calendar and Fiscal.
The options for the Calendar hierarchy levels are the following:
TOTAL: 1 members
CALENDAR_YEAR: 10 members
CALENDAR_QUARTER: 40 members
MONTH: 120 members
The options for the Calendar hierarchy levels are the following:
TOTAL: 1 members
FISCAL_YEAR: 11 members
FISCAL_QUARTER: 40 members
MONTH: 120 members
The CALENDAR_QUARTER option is selected to be partitioned and MONTH in the CALENDAR hierarchy is designated to be in the partitions.
Above the Aggregation Hierarchies options are the Order Hierarchies and Clear Selections buttons. Below the Aggregation Hierarchies options is a table. The columns of the table are Partition Order, Partition Name, Partition Includes, and Precompute. The table has one row, which has the following values: 1, CALENDAR.CALENDAR_QUARTER, CALENDAR_QUARTER, MONTH, 40.
Below the table is the Automatically Manage Partition Order option, which is selected.
Below that option are the Help, Apply, and Revert buttons.