Creating Clear Cube Jobs

You create a Clear Cube job to clear the data in a cube.

To create a job to clear a cube:

  1. From the Home page, click Application, and then click Jobs.

  2. Click the App Maintenance tab at the bottom of the Jobs console.

  3. On the App Maintenance tab, click Create Job.

  4. In Job Type, click the drop-down and select Clear Cube.

  5. In Job Details, enter a name for the job, and select a cube to clear.

  6. Select what you would like to clear:

    Clear Option Description
    Clear All

    Clear All: Clears all data in a cube that is associated with the selected clear options.

    For both block storage and aggregate storage cubes,you can select to clear:

    For block storage cubes only, you can select to clear:

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

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

    • Dynamic blocks: Clears data in dynamic blocks

    • Empty blocks: Clears blocks with #MISSING values

    All Aggregations

    Clears all aggregate views. For more information on aggregation, see Aggregating an Aggregate Storage Database.

    Partial Data (Basic Mode)

    Clears the data in the specified regions. Use the member selector Icon to Access the Member Selecter to select the point of view. You can select to clear:

    • Supporting Details

    • Comments

    • Attachments

    • Essbase Data

      • Logical: 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.

      • Physical: 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. This option decreases the size of the database.

    Partial Data (Advanced Mode)

    Clears Oracle Essbase data only by using an MDX expression in the text box provided. Select Logical or Physical (see the descriptions above) to specify how to clear the data.

  7. Click Save.

  8. Return to the App Maintenance tab to view the Clear Cube job.

Tip:

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