Merging Incremental Data Slices

You can merge all incremental data slices into the main database slice, or merge all incremental data slices into a single data slice while leaving the main database slice unchanged.

To merge slices, you must have the same privileges as for loading data (Administrator or Database Manager permissions).

Note:

You can only merge incremental data slices for aggregate storage databases only.

To merge incremental data slices:

  1. In System View, click Database Properties icon.
  2. In Enterprise View, right-click the plan type that contains the database whose data you want to merge, then select Merge Data, and then select one of these options:
    • All, to merge all data slices into one

      • Keep cells with zero value (default)

      • Remove cells with zero value

    • Incremental, to merge incremental data slices into one and do either of these:

      • Keep cells with zero value (default)

      • Remove cells with zero value

  3. In the Confirm Merge Data Action dialog, click OK to confirm you want to merge the data.