A nice Perl script that I built in order to manage and size databases caches every night. Not sure that it is perfect but we run it in production since a few months and it seems to work fine up to now. By the way we only have buffered I/O cubes.

The following Perl script takes the following arguments : application and database name and cache type.

 How to call : perl.exe confcaches.pl "application" "database" "buffered"

Merging Essbase audit logs

If you always wanted to merge your Essbase audit files for quick troubleshooting then you may have a look at this Perl code.
 
 The Java version witch include a GUI is available here

Essbase Rightlog lite version

Lately I reviewed my rightlog Perl script making a light version and correcting a few bugs. The script takes any Essbase server or application log as input.

This lite version doesn't provided a deep analysis with SQLite db as the original version and doesn't provide a native Excel output. The idea was to make it work in any Perl environment without any specific module.

You may also compile this Perl script using PAR which is a great Perl module. I installed PAR module through Perl Package Manager (graphical or command line : ppm.bat) and compiled RightLogLite.pl using the following command : pp -o x:\RightLogLite.exe c:\RightLogLite.pl

RightLogLite is also available as a download here