Oracle EPM Cloud Planning and How to Restructure Cubes for optimal performance

You can run the Restructure Cube job to perform a full restructure of a block storage cube to eliminate or reduce fragmentation. This will also remove empty blocks.

This feature is not applicable for an Aggregate Storage cube (ASO).

Note:

You should not run this job during the application maintenance time. You also should not launch a consolidation process while the Restructure Cube job is running.

When you perform this operation:

• Users will be prompted to log out.

• You must manually set the application to Maintenance mode.

• After the Restructure Cube job is run, you must manually turn off Maintenance mode.

• Users will then be informed that the application is available.

Running the Restructure Cube Job

To restructure a cube:

1. On the Home page, click Application.

2. Click Jobs.

3. Click Schedule Jobs.

4. Select Restructure Cube, then select Run Now, and click Next.

5. Select when to run the job:

   • Run Now

   • Schedule starting from, and then select the date, time, and time zone.

6. Enter a Name for the job.

7. For Recurrence pattern, select how often to run the job, and optionally, select an End Date.

8. Click Next to continue.

9. Select a Cube from the drop-down list, then click Next.

10. Review your selections and then click Finish.

    The Restructure Job is submitted on the Jobs page. Make sure that the job is completed by periodically refreshing the page.