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.