ExoInsight provides functionality to export and parse level-0 data from an Essbase cube to relational format. The command allows you to either point the process to an existing Essbase level-0 extract, or have the process export the data at runtime.
The command must be run from the
<installation directory>/casabase
directory. Upon extraction, all exports will land in the
<installation directory>/casabase/data
directory.
At a command prompt, the following command can be run:
java -cp "./*" ASOExportParser env app cube user password outlineXmlFile parsedDataFile dataInFile bExportData bExportOutline
The parameters are as follows:
Parameter |
Name |
Description |
1 |
env |
The ExoInsight environment name |
2 |
app |
The Essbase application name |
3 |
cube |
The Essbase cube name |
4 |
user |
The Essbase user name |
5 |
password |
The Essbase password |
6 |
outlineXmlFile |
The destination file for the parsed outline (if enabled) |
7 |
parsedDataFile |
The destination file for the parsed level-0 data |
8 |
dataInFile |
The filename for the Essbase level-0 extract |
9 |
bExportData |
Controls whether the Essbase data is exported at runtime. Default is true. |
10 |
bExportOutline |
Controls whether the Essbase outline is exported and runtime. Default is true. |
For example, the following command exports both the outline as well as the level-0 from the ASOsamp cube, referencing the prod ExoInsight environment, and lands the parsed data in the ASOexport.txt file.
java -cp "./*" ASOExportParser "prod" "ASOsamp" "Sample" "admin" "password" "ASOSamp.xml" "ASOParsed.txt" "ASOexport.txt" "true" "true"
After the command completes, the ASOParsed.txt file will exist in the
<installation directory>/casabase/data
directory, as well as the ASOSamp.xml file that contains the outline in XML format.
If you already have an existing level-0 export that you would like parsed, simply place it in the
<installation directory>/casabase/data
directory and modify the dataInFile parameter to reference the filename.