My first CDF : @RANDOM

I recently wrote my first CDF using Netbeans IDE 6.9.1. This CDF is really simple and is not based on JAPI or any other external libraries, @RANDOM just returns a random value! Quite basic but useful to populate your database with random data.

Have a look at the Java class below, once compiled in a jar and copied to Essbase,  you may register it using the following MaxL instruction :

CREATE OR REPLACE FUNCTION 'Sample'.'@RANDOM' AS 'myCdf.random' SPEC '@RANDOM()' COMMENT 'Return a random value';

Extract your Essbase outline with OutlineReader

OutlineReader  is a Java package (jar) made to extract Essbase outline structure (parent-child format) and its properties (alias, formula, uda, attribute...), making it a good way to document your database outline.

I got inspired by Outline Extractor utility, currently maintained and supported by AppliedOlap and originally developed by OlapUnderground. 

OutlineReader is also widely inspired by the ReadOutline.java class that is available in the Provider Services JAPI samples (please refer to Hyperion\products\Essbase\aps\samples directory).

OutlineReader is based on Essbase Java API v.11.1.1.3 (JAPI) and was pre-compiled using JDK 1.5. As IDE I used Netbeans IDE 6.8 and lately 6.9.1. I also used Apache CLI (Command Line Interface) in order to simplify the development of the command line interface.

OutlineReader is free and is open source software (MIT license), please feel free to contribute!

OutlineReader and its sources may be downloaded from 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).