mardi 30 mars 2010

Adjust menu for Essbase add-in

Adjust menu for my Essbase classic add-in toolkit. I just got inspired by Smart View's Adjust functionality, except that here you may use color to identify adjusted cells!
Find the code below, as you'll see it may not be the most beautiful VBA code but it should be clean enough for your understanding - btw I let you traduce the comments!
Adjust menu for Essbase Excel add-in

lundi 29 mars 2010

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

dimanche 28 mars 2010

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

Validate Essbase filters

Here is a small but efficient piece of Java code (+JAPI library) made to list, verify and validate Essbase filters.
I was inspired by the JAPI code samples available in APS (Provider Services) directory (%APS_HOME%\samples\japi) and the rest was guided by my imagination and needs. By the way it also displays user and groups assigned to the filter.
We run this script every night and then add it to the server export package together with other maxl exports, Essbase.cfg and SEC's backup. So we have a daily file ready for any security audit.

I did not post any compiled code as this is not a big deal doing it in Eclipse or Netbeans. just don't forget adding JAPI library before compiling (%APS_HOME%\lib\ess_japi.jar).