1. Configuration Reference for Oracle Essbase
  2. Configuration Reference Overview
  3. Set Application-Level Configuration Properties

Set Application-Level Configuration Properties

If you have the Service Administrator role, or the Power User role for applications that you created, you can customize Oracle Essbase using application-level configuration properties. Application-level configuration properties apply to all cubes in the application.

One way to specify configuration properties of an application is to do it prior to building the application and cube, using the application workbook. To see an example, go to Files in the Essbase web interface, and download the application workbook Sample_Basic.xlsx. It is located in the gallery, in the Demo Samples section (under Block Storage). In this application workbook, go to the Cube.Settings worksheet. Under Application Configuration, the DATACACHESIZE property is set to 3M, and the INDEXCACHESIZE property is set to 1M.


Application configuration specification in the application workbook for Sample Basic. On the Cube.Settings worksheet, in the Application Configuration area, DATACACHESIZE property is set to a value of 3M, and INDEXCACHESIZE property is set to a value of 1M.

The following steps tell you how to configure an application that is already deployed, by adding properties and their corresponding values in the Essbase web interface.

  1. On the Applications page, select the application you want to configure.

  2. Click Configuration.

  3. To add a property, click Add.

    Scroll through the list or search for a property.

  4. Click Image of the Redwood Add icon. to add the property to the list.


    Search element in application configuration interface: clicking + next to a configuration property to add it

  5. Click Image of the X icon to close application configuration search in Redwood to close the search tool.


    Image of the app config search tool with the Close icon highlighted.

  6. In the Value column, double click to enter a value.


    Application configuration interface with ASODEFAULTCACHESIZE configuration property added, and the Value text field active as value 200 is being entered manually

  7. When you’re finished making changes, click Apply and Restart.

    Note:

    If the application is not started, you are given the option to "Apply" rather than "Apply and Restart." Changes will be applied the next time the application is restarted.

  8. Wait for the confirmation message.


    Confirmation message, reading: Configuration settings were applied successfully and the application will be restarted.

  1. On the Applications page, select the application you want to configure.

  2. From the Actions menu to the right of the application, click Inspect, then click Configuration.


    Application configuration interface with no configuration properties added

  3. To add a property, click Image of the add icon. Scroll through the list or search for a property.

  4. Click Image of the add icon to add the property to the list.


    Search element in application configuration interface: clicking + next to a configuration property to add it

  5. Click Image of the X icon to close to close the search tool.


    Search tool with configuration properties listed and X to close the tool

  6. In the Value column, double click to enter a value.


    Application configuration interface with ASODEFAULTCACHESIZE configuration property added, and the Value text field active as value 200 is being entered manually

  7. When you’re finished making changes, click Apply and Restart.

  8. Wait for the confirmation message.


    Confirmation message reads "Configurations are applied successfully and the application is restarted"

For syntax and information about each of the application configuration properties you can use, see Config Settings List. You do not need to use the optional [<appname>] syntax when adding properties to the application configuration.

Oracle does not recommend that you modify essbase.cfg on the Essbase file system. This configuration is automatically set.