The EssbaseRightLog perl script and related executable parse ANY Oracle Hyperion Essbase® v.5-v.9 (aka. Analytic Services®, Essbase Analytics®) server or application logs and generates a full, custom delimited, output for enhanced analysis (database, spreadsheet).
EssbaseRightLog is intended to help Essbase® and Planning® database administrators and developers. Any Essbase® generated log 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) by facilitating their integration and filtering in a spreadsheet (common logical delimiter). Reconciled logs may be inserted as well in a relational database for querying or statistics production.

EssbaseRightLog_vxx.exe is a compiled version of EssbaseRightLog_vxx.pl. The executable was generated by a licensed version of Perl2Exe v.9.1.

Options available

• 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,
• Export to Excel workbook (filtered and paned) whatever the size of the log file (supports logs with more than 65536 rows on Excel 2000/XP/2003).

Screenshots

http://roux.sebastien.googlepages.com/essbaserightlog

Availability

EssbaseRightLog is available in the GOOGLE CODE HOSTING downloads section as a single perl script, which require a perl interpreter. It may be run under Windows/UNIX/Linux environments with a recent Perl interpreter.
EssbaseRightLog is available in the GOOGLE CODE HOSTING downloads section as an Win32 executable generated by a licensed version of Perl2Exe v.9.1.

GOOGLE CODE HOSTING

Instructions of use

Usage: perl EssbaseRightLog.pl -i <logfile(s)> [-o <outputfile>, -c, -d <arg>, -t, -s <arg>, -f <arg>, -h] Usage: EssbaseRightLog.exe -i <logfile(s)> [-o <outputfile>, -c, -d <arg>, -t, -s <arg>, -f <arg>, -h] -i specify Essbase log(s), args: <file1[;file2;...]> -o specify output file, args: <outputfile> -c specify message categories -d specify date format, arg: <ISO|EUR|US> -t specify headers on top -s specify separator, arg: <*> -f specify filter (case sensitive), arg: <*> -x specify export to Excel, arg: <outputfile> -h display usage

Examples

Filtering: lately I just created a few batches with my own rules, find below some useful examples of what can be done.

• Trace calculations based on a regexp filter (-f "1013091.*Calculate|1012550.*Elapsed") from different applications (-i), inserting categories (-c) and headers (-t), and formatting date to European standard (-c EUR): rightlog.exe -i Y:\App\App1\App1.log;X:\App\App2\App2.log -o c:\calcs_logs.txt -c -d EUR -t -f "1013091.*Calculate|1012550.*Elapsed"

• Trace every connection that has been done on your applications. rightlog.exe -i Y:\App\App1\App1.log;X:\App\App2\App2.log -o c:\connections_logs.txt -c -d EUR -t -f 1013210

• Trace all Error or Warning strings that are present in your applications' logs. rightlog.exe -i Y:\App\App1\App1.log;X:\App\App2\App2.log -o c:\ErrWar_logs.txt -c -d EUR -t -f "Error|Warning"

Excel Export:

• Export to Excel workbook including headers, categories and ISO date formatting rightlog.exe -i C:\Hyperion\Essbase93\Essbase.log -x c:\mylogs\Essbase20080326.xls -c -t -d ISO

Current version and release notes

v.2.5.2 2008/03/26 - Added export to Excel paned and filtered workbook feature

- Updated usage text

v.2.2 2007/12/04 - Corrected display error in usage text

- Updated Essbase Server and Application Log Message Categories for Essbase 9.3.1 (see -c option)

v.2.1 2007/12/02 - Removed unused code

v.2.0 2007/12 - Renamed from previous version (Essbase Log Reconciler) and revamped

- Added new features such as string filtering, custom delimiter ...

By the way I've never seen such a BAD wiki system...