Specifying and Changing Database Settings

Before you change database settings, review information about precedence of the settings as changed in different parts of Essbase, and how Essbase reads those settings:

  To specify most database settings, use a tool:

Tool

Topic

Location

Administration Services

Setting Database Properties

Oracle Essbase Administration Services Online Help

MaxL

alter database

Oracle Essbase Technical Reference

ESSCMD

SETDBSTATEITEM

SETDBSTATE

Oracle Essbase Technical Reference

These methods provide different ways to change the same database settings. In rare cases, you may want to use essbase.cfg to specify settings.

Caution!

In previous versions of Essbase, you can specify many database settings in the essbase.cfg file on Essbase Server. In Version 5.x and later, Essbase overrides most of the .cfg settings. For an explanation of how newer versions of Essbase handle settings, see Understanding the Precedence of Database Settings and Understanding How Essbase Reads Settings.