Monday, February 23, 2009

Automation of Dimension extraction

Hi Guys,
good morning.
today we will learn how to automate dimension extraction from essbase.
There is a very good utility called outline extractor in

Step # 1
As a first step you should install Outline extractor.

Step # 2

Build a batch file providing details of your application and database and dimension you want to extract as follows:

cd C:\Program Files\olapunderground\Essbase Outline Extractor

win C:\Program Files\olapunderground\Essbase Outline Extractor\exportdim.exe ServerName/AdminName/Password/ApplicationName/DatabaseName/DimensionName/Path where extracted file to be stored/!/ Doc/11111111111111111111/Text

You can schedule the above batch file to run at fixed time using various schedulers like Window scheduler etc.

Hope this helps.
Have a BLESSED day.

No comments:

Post a Comment