Setting Database Properties

You can view and edit properties for one Essbase database from one window or for multiple databases from multiple windows.

To apply settings throughout Essbase, you may be able to use the essbase.cfg configuration file. For information about how to create this file and about what settings are available, see the Oracle Essbase Technical Reference.

  To set database properties:

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

2. Right-click, and select Edit, and then Properties.

3. Set one or more of the following properties:

   • Configuring Databases to Start Automatically

   • Aggregating Missing Values During Calculation

   • Enabling Create Blocks on Equations

   • Using Two-Pass on Default Calculations

   • Setting Retrieval-Buffer Sizes

   • Enabling Cache Memory Locking

   • Setting Cache Sizes

   • Setting Data Integrity Options

   • Selecting I/O Access Modes

   • Selecting Data Compression Methods

   • Setting Disk Volumes

   • Linking a Database to a Currency Database

Related Information

• Database Properties Window

• About Database Monitoring

• “Improving Essbase Performance” in the Oracle Essbase Database Administrator's Guide

Related Commands

• alter database (MaxL) in the Oracle Essbase Technical Reference

• display database (MaxL) in the Oracle Essbase Technical Reference

• getdbinfo (ESSCMD) in the Oracle Essbase Technical Reference

• getdbstate (ESSCMD) in the Oracle Essbase Technical Reference

• getdbstats (ESSCMD) in the Oracle Essbase Technical Reference

• setdbstate (ESSCMD) in the Oracle Essbase Technical Reference

• setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference