Partitioning Method
Three options are provided for handling Measure Group partitions. They are:
1 One partition only
When this option is selected the partition information for the Measure Group is ignored and one partition is created and processed for the Measure Group. This would be the normal situation unless performance issues require an alternate strategy.
2 Manually managed multiple partitions
With this option the partition information stored for the Measure Group is used in the creation and processing of the Measure Group.
3 Automatic partition handling
This option is available if the Measure Group is to be partitioned by one numeric value. The partitioning should preferably be on something like day, month or year. (i.e. YYYY, YYYYMM or YYYYDDD). If this option is chosen together with one of the date formats described above, then QAD Data Warehouse Designer will automatically create partitions as required and process only those partitions that are marked for processing.