Description

RightLogLite is a Perl script that parses and reformat ANY Oracle Essbase server or application log.

RightLogLite is similar to EssbaseRightLog as it parses Essbase logs, however RightLogLite doesn't require any external module but it contains then less features. As EssbaseRightLog, RightLogLite is intended to help Oracle Essbase® and Oracle Planning® database administrators and developers.

Essbase logs may be parsed whatever the delimiter defined in Essbase.cfg config file (please refer to DELIMITEDMSG TRUE, DELIMITER in Oracle’s Essbase® Technical Reference). The idea was to make the logs really readable (one liner), making easy their analysis in a spreadsheet (common logical delimiter) or their insertion and querying in a relational database.

RightLogLite may be compiled as a Windows executable (exe) using PAR module (Perl Archive) available on CPAN.

Options available

• Search for specified files or directories (.LOG)
• Advanced date formatting (US, European or standard ISO)
• Headers insertion
• Detailed message categories (please refer to Essbase Server and Application Log Message Categories in DBAG)
• String filtering
• Custom separator

Availability

EssbaseRightLog is available in the download section as a single Perl script and may be run under any environment hosting a Perl interpreter (no external module is required).

Instructions of use

``` USAGE: perl RightLogLite.pl [-i | -p ] [-o , -c, -d , -t, -s , -f , -x , -q, -h]

-i specify log file(s), args: -p specify log directory, recursive search for .LOG files, args: -o specify output file, arg: -c specify message categories -d specify date format, arg: -t specify headers on top -s specify separator, arg: <> -f specify filter (case sensitive), arg: -h display usage ```

From the same author

outlinereader - Export Essbase outline structure and properties

jssauditmerger - Merge your Oracle Hyperion Essbase® spreadsheet audit logs for better analysis (Java version)

ssauditmerger - Merge your Oracle Hyperion Essbase® spreadsheet audit logs for better analysis (PERL version)

jrightlog - Parse ANY Oracle Hyperion Essbase® server or application logs and generates a full, custom delimited, output for enhanced analysis (database, spreadsheet) (Java version)

essbaserightlog - Parse ANY Oracle Hyperion Essbase® server or application logs and generates a full, custom delimited, output for enhanced analysis (database, spreadsheet) (PERL version)