The Measure Group Partition's properties are shown by right-clicking the Measure Group Partition displayed in the middle pane and then selecting Properties. The partition's properties associated with a measure group are described below.
Fields | Description |
|---|---|
Cube Name | The name of the cube that the partition belongs. |
Data Source | The data source for the partitions. This will be inherited from the cube and cannot be changed. You cannot have partitions with different data sources or different fact tables in WhereScape RED. If you need to support either scenario, then the partition must be created directly within Analysis Services. In such a case, it can still be managed in terms of processing through WhereScape RED. |
Fact Table | The fact table that the data is derived from. This is inherited from the cube and cannot be changed. See the notes above under data source. |
Update Buttons | The Update Buttons: Update <- and Update -> are used to move from the current Measure Group Partition to the previous and next Measure Group Partition respectively for the current Measure Group. The alternative is to exit the Measure Group Partition and choose the next Measure Group Partition Properties screen. |
Partition Name | Where only one partition exists, it is normally given the same name as the cube. If manually creating, then a unique name must be assigned for each partition. If auto partitioning is chosen, then WhereScape RED uses the cube name plus the level value to make the partition name. |
Partition Description | A description of the partition for documentation purposes. |
Data Slice Formula | This field defines the range of data stored in the partition. It is a very simplified version of what can be done in Analysis Services. If a more complex partitioning algorithm is required, then the partition must be created in Analysis Services. The format for the formula is as follows: The brackets must surround each name and a full stop must separate the three parts of the formula. For example, a cube that is partitioned by year on its date dimension would have the following formula for the 2003 year:
|
Aggregation Prefix | By default, any cube aggregation is prefixed with the partition name. An alternate name can be entered here. Refer to Analysis Services for details. |
Filter Statement | Not implemented. |
Storage Mode | This field has two options: MOLAP (Multidimensional OLAP) or ROLAP. (Relational OLAP). This determines how the OLAP cube is processed. The default value is inherited from the value set at the Measure Group level. |
Partition Type | The partition can be either Local or Remote. Local means that the partition resides on the same Analysis Services server as the cube. If Remote is chosen, then a server must be specified where the partition will be located. |
Remote Server | If a Remote partition, then the name of the remote Analysis Services server must be entered here. |
Processing Method | A partition is either enabled for processing or disabled. This field can be set to Always process or Never process. If left as default and in automatic mode, then WhereScape RED deactivates the processing, once the partition has been aged out. |