1. Administering Financial Consolidation and Close
  2. Managing Applications
  3. Restructuring Cubes

Restructuring Cubes

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.

Determining When to Restructure a Cube

To determine when to restructure a cube:

  1. On the Home page, click Application, and then click Consolidation.

  2. From the Consolidation Process page, click a user-editable rule, for example, Final Calculations.

    A user-editable rule is indicated by the User icon. When you click a rule, it launches Calculation Manager in a separate tab in the browser.

  3. In Calculation Manager, click the Database Properties toolbar button.

  4. From Database Properties, expand the "Planning" folder, and the application name, and check if the application's databases are running. There should not be a red box for the database.

  5. Click on Consol database and navigate to the Statistics tab.

  6. Check the Average clustering ratio property.

    • If the value is close to 1 (1 is the maximum), there is no need to restructure the cube.

    • If the value is not close to 1, for example, 0.0132828, you should restructure the cube.