1. Database Administrator's Guide for Oracle Essbase
  2. Work with Essbase Outlines
  3. Move and Compare Dimensions and Members

Move and Compare Dimensions and Members

After you create dimensions and members, you can rearrange them within the Essbase outline. If needed, you can compare two outlines side by side, and you can copy and paste members between two outlines.

Before moving members and dimensions in an outline, consider the following information:

  • The positions of dimensions and members in an outline can affect performance.

    See Optimize Outline Performance with Attributes.

  • Moving dimensions and members can affect the performance of calculations and retrievals.

    See Design an Outline to Optimize Performance.

  • Moving members could move a shared member before the actual member in the outline (which is not recommend).

  • If you add, delete, or move non attribute dimensions or members, Essbase restructures the database, and you might need to recalculate the data.

  • Position attribute dimensions at the end of the outline.

To work with dimensions and members in the Essbase web interface, refer to Create and Manage Cube Outlines Using the Web Interface. To work with dimensions and members using REST API, refer to Run Batch Outline Edit.