Monday 29 February 2016

Hyperion Essbase/Planning Outline Exfiltrator

Well, this is the first look at the Hyperion Essbase Outline Exfiltrator( I think I was watching some war movie or playing a game when I came up with this name...But you have to pardon me, these are a few luxuries that I have in life .... Coming up with weird names for simple things... By the way, the Essbase Log File parser will be called "Agamennon" so don't be surprised :P )

This is an alpha version which means that the code is bad, I have not added the bells and whistles, some hard coding will be there, but it works and it works beautifully...

This is the sample application outline that I will be extracting for the blog.

It is pretty simple and straight forward... Kind of "Hello World" for Essbase...

The outline extractor looks as follows... Some fields are blacked out, but in later versions I will try to come up with the product as is






I navigate to the application and click the "Extract OTL" node... The screenshot after that is as follows:-




For the demo, I am running the extract all dimensions...I still have to code the extract specific ones.. Then I just hit the submit button...

In the above snapshot, you can choose the directory where you want the hierarchy information to be extracted. I have chosen the "Desktop". The files have the following naming convention:- "Appname-DBName-DimensionName.txt"


The outline information extracted in the files is as follows:-







Since this is an alpha, some things may move here or there, but overall this works...

Do let me know your suggestions for the same...