1. Administering Planning Modules
  2. Followup Administrative Tasks
  3. Maintaining Your Application
  4. Best Practices for Optimizing Dimension Order

Best Practices for Optimizing Dimension Order

Follow these best practices to optimize dimension order in Planning Modules.

Over time, as you load metadata, dimension order might not be optimal.

You can configure the dimension order so that the order follows best practices, which optimizes application performance. The order is automatically configured based on best practices, depending on whether the application is hybrid enabled or not.

You can also restore the dimensions to the order that was set when you enabled features.

Considerations:

  • Before you optimize dimension order, refresh the database and then back up the application and download the snapshot. See Backing Up and Restoring an Environment Using the Maintenance Snapshot in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators. This procedure will change the order of dimensions.

  • Perform this task in your test environment before performing it in the production environment.

  • This feature is available only for Financials and Projects, and only for the provided BSO cubes that are created when you enable and configure.

  • This new order is maintained even if you enable additional features or other modules.

To optimize dimension order:

  1. From the Home page, click Application and then click Configure.
  2. Select Financials or Projects from the Configure list.
  3. From the Actions menu, click Optimize Dimension Order.
  4. Review the existing dimension order and compare it to the recommended proposed order.
  5. To reorder the dimensions, click Apply.

    If there are no required changes to the dimension order, Apply is not available.

  6. Confirm that you have refreshed the database, backed up your application, and downloaded the snapshot, and then click Continue.
  7. Refresh the database to apply the changes.

You can also click Restore Dimension Order if you want to restore the dimensions to the order that was set when you enabled features. Note that this action does not roll back or undo any dimension order changes that were applied. The restored dimension order will be similar to the order in a new application.