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!!!!!!
I read a lot of blog posts and I never come across such a helpful post. I like this post you made with great effort. Very ingenious.
ReplyDeleteHyperion Planning Online Training
Hyperion Planning Training
Did you hear there is a 12 word sentence you can tell your crush... that will induce deep emotions of love and instinctual attraction to you deep inside his heart?
ReplyDeleteThat's because hidden in these 12 words is a "secret signal" that triggers a man's instinct to love, admire and guard you with all his heart...
12 Words Will Trigger A Man's Love Response
This instinct is so hardwired into a man's brain that it will make him work better than before to build your relationship stronger.
As a matter of fact, fueling this powerful instinct is so mandatory to getting the best possible relationship with your man that the moment you send your man one of the "Secret Signals"...
...You'll soon find him expose his soul and mind for you in a way he's never expressed before and he'll distinguish you as the one and only woman in the universe who has ever truly tempted him.