1. Administering and Working with Enterprise Profitability and Cost Management
  2. Creating and Managing Applications
  3. Managing Applications
  4. Managing Cubes
  5. Clearing Cubes
  6. Creating Clear Cube Jobs

Creating Clear Cube Jobs

To create a Clear Cube job:

  1. From the Home page, select Application, and then select Overview.

  2. On the Application page, select Actions, and then Clear Cube.

  3. On the Clear Cube page, click Create.

  4. Enter the job name and select the cube to clear.

  5. Select what you would like to clear:

    • Clear All: Clears all data in a cube that is associated with the selected Clear Options. You can select to clear:

      • Supporting Details

      • Comments

      • Attachments

      • Essbase Data

    • All Aggregations: Clears all aggregate views. For more information on aggregation, see Aggregating an Aggregate Storage Database in the Essbase Database Administrator's Guide.

    • Partial Data (Basic Mode): Clears the data that is associated with the selected Clear Options. 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.

  6. Click Save and Close.

  7. Click Refresh to view the Clear Cube job.

  8. Select whether to run the Clear Cube job now or at a later time.

    • To run the job right away, click Actions icon next to the job, and then select Submit. If the job submitted successfully, click OK, and then click Close to return to the Application screen.

    • To run the job at a later time, or at intervals, click Close to return to the Application page, and then schedule the job in the Jobs console. See Scheduling Clear Cube Jobs for information on how to do this.