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.
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.
-
On the Applications page, select the application you want to configure.
-
Click Customization, and then click Configuration.
-
To add a property, click Add.
Scroll through the list or search for a property.
-
Click to add the property to the list.
-
Click to close the search tool.
-
In the Value column, double click to enter a value.
-
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. -
Wait for the confirmation message.
-
On the Applications page, select the application you want to configure.
-
From the Actions menu to the right of the application, click Inspect, then click Configuration.
-
To add a property, click . Scroll through the list or search for a property.
-
Click to add the property to the list.
-
Click to close the search tool.
-
In the Value column, double click to enter a value.
-
When you’re finished making changes, click Apply and Restart.
-
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.