For one
of the OAC (Oracle analytics Cloud) customer need to export the data from an
existing OAC Essbase application and need to load that data to a new OAC
Essbase applications.
There are
multiple ways we can export the data from an existing OAC Essbase applications,
but since the amount of data it has so huge we chose to export the data using
the Essbase web interface, on the
Applications page, expand the application, and select the respective cube
- From the Actions menu,
select Export to Excel.
- On the Export To Excel
dialog box, select the Parent-Child Export Build Method.
- Select Export Data and
click OK
It will export the complete application in a Excel sheet, on opening you will find different sheets for each dimension and a tab for the data.
As i said since the application contains lot of data this is what it says when you look under the sheet for data,
As it says it creates a .zip file for the data under Files. The interesting factor about the data file is it creates a column for each dimension and in our case we have multiple "Scenarios" as follows
When looked at the data exported file
Its listing all the Scenario members with starting and ending with "Scenario"
So i deleted the "Scenario" and made the header as a single row which will allow me to create a rule file and load the extracted data file as it is.
So i did change the headers as follows
Hope this was useful, Happy days ahead with Cloud!!!!!!
