Merging Data Slices and Removing Zeros Using A Job

Jobs are actions that you can schedule to start at a convenient time. To merge data slices you create and schedule a Merge Data Slices job.

To merge incremental slices and remove zeros using a job:

1. Sign in to Oracle Enterprise Performance Management Cloud.
2. Click Application, then Jobs, and then click Schedule Jobs.
3. Select Merge Data Slices as the job type.
4. In Name, enter a name for the job.
5. Select when to run the job. You can run a job right away or schedule it to run at a later time.
6. Click Next.
7. Specify merge options in Job Details:
   1. Select the cube.
   2. Select how you want to merge data slices. Choose one of the following:
      • Merge all into the main slice to merge all data slices into the main data slice.
      • Merge all into a single incremental slice to consolidate all data slices.
   3. Under Merge Options, select Remove cells with zero value to replace 0 with #Missing as the value in cells from which data has been cleared prior to the data push.
8. Click Next and then review the selected job settings.
9. Click Finish.