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, you can see that the DATACACHESIZE property is set to 3M, and the INDEXCACHESIZE property is set to 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. From the Actions menu to the right of the application, click Inspect, then click Configuration.
   
   

   

   
   
3. To add a property, click . Scroll through the list or search for a property.
4. Click to add the property to the list.
   
   

   

   
   
5. Click to close the search tool.
   
   

   

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

   

   
   
7. When you’re finished making changes, click Apply and Restart.
8. Wait for the confirmation message.
   
   

   

   
   

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.