OUTLINECHANGELOG

The OUTLINECHANGELOG configuration setting controls whether Essbase keeps a history of outline modifications.

Syntax

OUTLINECHANGELOG TRUE | FALSE

TRUE—Essbase logs outline changes into the file database_name.olg.
FALSE—Essbase does not log outline changes. This is the default.

Description

If OUTLINECHANGELOG is set to TRUE, Essbase logs all outline changes into the file database_name.olg. Database administrators can review the outline revision history in the .olg file and gather enough information to roll back changes if needed.

Each database (cube) contains a separate outline change log file in the cube directory.

The data format of the outline change log is:

Date and time of outline modification
Name of the user who made the change
Type of change the user made
Details describing the type of change made

Notes

During a restructure, Essbase holds outline change information in memory until all updates have been made to the outline change log. Turning on the outline change log might affect your restructure performance, particularly after dimension builds of several hundred or more members.
To set the size of the outline change log, use the OUTLINECHANGELOGFILESIZE parameter.

Example

OUTLINECHANGELOG TRUE