Description

Merge Essbase® or Analytic Services® (v.5 - v.9) SSAudit logs (SpreadSheet Audit) from specified directory. Please refer to SSAUDIT, SSAUDITR cfg's settings in Oracle’s Essbase® Technical Reference).

Options available

• Advanced date formatting,
• Headers filtering.

Availability

SSAuditMerger is available in the 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.

SSAuditMerger is available in the downloads section as an Win32 executable generated by a licensed version of Perl2Exe v.9.1.

Instructions of use

Usage: perl SSAM.pl -i <.atx & .atg directory> [-o <outputfile>, -d <arg>, -h]

Usage: SSAM.exe -i <.atx & .atg directory> [-o <outputfile>, -d <arg>, -h]
  -i specify SSAudit logs' directory, args: <directory>
  -o   specify output file, arg: <outputfile>
  -d   specify date format, arg: <ISO|EUR|US>
  -f   specify filter on headers (case sensitive), arg: <*>
  -h   display usage

Examples

Change date format to European one (dd/mm/yyyy), filtering input on march 2008.

C:\>ssam.exe -i c:\downloads\ssaudit_logs\ -o c:\archives\ssaudit_log\output.txt -d eur -f 03/2008

You may use Perl regex to enrich your filter, here I filter logs for lock&send done in april 2008 for users Admin OR Nimda.

C:\>ssam.exe -i x:\App\Medicam\alg_atx\ -o c:\ssaudit\Medicam.txt -d eur -f "04/2008.*(Admin|Nimda)"

To come...

• Output to SQLite embedded database