Dayalan Punniyamoorthy Blog

Showing posts with label Oracle Analytics Cloud. Show all posts
Showing posts with label Oracle Analytics Cloud. Show all posts

Wednesday, August 28, 2019

Exporting and importing data in OAC!

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!!!!!!



Wednesday, March 27, 2019

Downloading the logs from the OAC Classic instance!!!

This is applicable only to Oracle Analytics Cloud - Classic

One of our Customer OAC instances went down and we raised an SR to work with Oracle, Yes you guessed right they did ask for the logs 😊




The first question on the mind since this on the Cloud and how can I get the logs from the cloud. Well, Oracle Analytics cloud (OAC) is different from Oracle Planning and budgeting cloud service (Oracle PBCS).