Creating Clear Cube Jobs

To create a Clear Cube job:

1. Click Application, and then click Overview.
2. Click Actions, and then Clear Cube.
3. On the Clear Cube page, click Create, complete the job name, select the cube, then select a clear option:

   • Clear All: For both block storage and aggregate storage cubes, delete all data within a cube that is associated with the entities you select:

     • Supporting Details

     • Comments

     • Attachments

     • Essbase Data

   • For block storage cubes only:

     • Upper-level blocks: Delete data in upper-level blocks

     • Non-input blocks: Delete data in non-input blocks

     • Dynamic blocks: Delete data in dynamic blocks

     • Empty blocks: Delete blocks with #MISSING values

   • For aggregate storage cubes only:

     • All Aggregations: Delete all aggregate views

     • Partial Data (Basic Mode): Clear the data in the specified region. You can select the point of view using the member selector .

       • Supporting Details

       • Comments

       • Attachments

       • Essbase Data Logical: In which the input cells in the specified region are written to a new data slice with negative, compensating values that result in a value of zero for the cells you want to clear. The process for logically clearing data completes in a length of time that is proportional to the size of the data being cleared. Because compensating cells are created, this option increases the size of the database.

       • Essbase Data Physical: In which the input cells in the specified region are physically removed from the aggregate storage database. The process for physically clearing data completes in a length of time that is proportional to the size of the input data, not the size of the data being cleared. Therefore, you might typically use this method only when you need to remove large slices of data.

     • Partial Data (Advanced Mode): Clear Essbase data only by using an MDX expression in the text box provided.

       • Essbase Data Logical: In which the input cells in the specified region are written to a new data slice with negative, compensating values that result in a value of zero for the cells you want to clear. The process for logically clearing data completes in a length of time that is proportional to the size of the data being cleared. Because compensating cells are created, this option increases the size of the database.

       • Essbase Data Physical: In which the input cells in the specified region are physically removed from the aggregate storage database. The process for physically clearing data completes in a length of time that is proportional to the size of the input data, not the size of the data being cleared. Therefore, you might typically use this method only when you need to remove large slices of data.

4. Click Save and Close.
5. To view the job on the Clear Cube listing page, click Refresh.

To start the Clear Cube job right away or to delete a job, see Starting and Deleting Clear Cube Jobs.

To schedule a Clear Cube job to run immediately, later, or at intervals, go to the Jobs page. See Scheduling Jobs .

Tip:

To streamline the job creation process for subsequent Clear Cube jobs, you can duplicate an existing job using the Save As option, then update it. See Duplicating Jobs.