Synchronizing Outlines

When you partition databases, you must be able to map all dimensions and members inside the partitioned area of the source database to corresponding dimensions and members in the target database. If you make changes inside the partitioned area of the source or target database outline, the partition may become invalid. For partitions to continue to function properly, you must return the outlines to a state where all of the partitioned dimensions and members on the source and target can be mapped.

Outline synchronization is a tool to help keep your outlines synchronized and to maintain your partitions.

Note:

You cannot use outline synchronization when an aggregate storage database is the source for a partition.

Outline changes may flow from a source database outline to a target database outline, or vice versa. Controlling the direction of outline changes between source and target databases is managed in the Create or Edit Partition window (Type tab). If you select the option Outline changes move in the same direction as data changes, the source and target outlines for outline synchronization are the same as the outlines for the source and target databases in the partition. If you do not select this option, the source and target outlines for outline synchronization are reversed; that is, the source outline for synchronization is actually the outline for the target database in the partition.

Note:

Administration Services cannot synchronize non-Unicode-mode outlines that contain multi-byte characters. A workaround is to use the MaxL Shell (essmsh) or ESSCMD to synchronize such outlines.

  To synchronize outlines:

  1. From Enterprise View or a custom view, select a source or target database.

  2. Under the database node, expand the Partitions node.

  3. Select the partition.

  4. Right-click and select Synchronize outline.

  5. In the Synchronize Outline dialog box, and under each of the following nodes—Dimension, Member, and Member property—select the changes to include in the outline synchronization and clear the changes you want to omit. If you choose to omit some changes, those changes cannot be applied later.

    If you want to include all changes, click Select All. If you do not want to include any changes, click Select None.

  6. If you want to purge out-of-date change logs on the target outline and the source outline, click Purge.

    Essbase deletes all records from the change log that have been applied or rejected. If all records have been applied or rejected, Essbase deletes the change log as well. Essbase does not purge records that have not yet been applied to the target outline.

  7. Click Apply.

Related Information

Related Commands