Administrators of Oracle Hyperion Essbase will often turn to the Essbase application log files for various research. For example:
- Tracking down the source of problems
- Monitoring calculation performance
- Reviewing user activity
However, despite these benefits, the Essbase application log often becomes large and unwieldy. You can easily open the latest day of activity in EAS, but it becomes much more difficult to review historical logs.
To alleviate the issue, you may consider using Large Text File Viewer software to view the logs, or minimize the log size by adjusting relevant Essbase server config properties. These may be topics for future blog posts. For purposes of this blog post, here is a recommended path you can take for opening the log files:
- Pull up the app log folder on the server. E.g.: C:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\essbase\essbase_0\app\[app name]\
- Copy the ODL files in the folder for the pertinent time period, and move them to a folder on your desktop.
- Open Notepad++. You may download it here if you do not already have it installed on your PC.
- Press Ctrl-F in Notepad++.
- Select the ‘Find in Files’ tab.
- Search the folder where the ODL files were copied, for whatever you are wanting to find (e.g. a calc script name).
- It will show the hits within individual ODL files. You can then open the pertinent ODL file(s). These files are much smaller in size than the Essbase application log.
If you need additional assistance with this, contact our team for support. We support clients daily on these types of issues, among a variety of other support services.
Additionally, you may leave comments below with any questions.