Contents of the Essbase Server Log

The information in the ESSBASE.LOG file can help you assess:

Table 140 lists the types of actions logged and the information included in the log message. For information about specific error messages, see the Oracle Essbase Error Message Reference.

Table 140. Contents of the Essbase Server Log

Type of Action

Information Included

Actions performed at the Essbase Server level, such as logging on Essbase Server or setting security

  • User name

  • Date and time

  • If changing permissions—User and group information and IP address of user

  • If logging on—Time and date the user last logged on

  • If logging off—Length of time the user was logged on

  • If creating or changing an application or database—Request to create or open the artifact; load, connect, and start the application or database to be created; and lock of the artifact to be created or changed

  • If creating, changing, or viewing an application or database—Requests to list applications and databases and requests to retrieve access information

  • Shutdown or startup requests

  • Requests to retrieve and delete the Essbase Server log

Actions performed at the application level, such as viewing application settings or viewing and changing custom-defined macros, custom-defined functions, and substitution variables

  • User name

  • Date and time

  • Requests to retrieve operating system resources, license information, and system-wide configuration

  • Retrieving and setting global values

  • If altering substitution variables—Request to list and set substitution variables

  • If altering custom-defined macros—Request to list and delete custom-defined macros

  • Requests to retrieve and delete the application log

Actions performed at the database level, such as creating rules files, outlines, reports, or calculation scripts

  • User name

  • Date and time

  • Requests to retrieve client settings, user, and group information

  • Requests to list applications and databases

  • Requests to retrieve access information

  • Requests to lock artifacts

  • Returning artifacts