Dayalan Punniyamoorthy Blog

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



Friday, May 31, 2019

New Groovy Training Available from Oracle!!!!

Wow i just saw this and cant help myself in advertising this, now we have the OBE (oracle by example) for the GROOOOOOOVYYYYYYYYY yahhhhhh enjoy...

Introduction to Groovy Business Rules
Learn about the Groovy scripting language and see how to create a Groovy script in Oracle Enterprise Planning Cloud.
Working with Data Grids and Iterators in Groovy
Implement Groovy scripts to work with data grids and data grid iterators. You use conditional logic to set the background colors in a data grid, implement performance benchmarking, and set default data values in a grid.
Moving Dimension Members with Groovy
Create a Groovy script to work with metadata, in this case, moving a member from one parent to another.
Moving Modified Data Using Groovy and Smart Push
Push data from a source location to a target location via Groovy rules.
Validating Data Entry Values with Groovy
Implement a Groovy script that validates data entry against allowed ranges stored in a driver cube.
Adding Dimension Members with Groovy
Create a Groovy script to work with metadata, in this case, adding a member to a dimension.
Calculating Modified Data Using Groovy
Generate a focused calculation script to calculate only data that has been edited, instead of the entire data entry form.
Integrating Data Between Planning and Strategic Models Using Groovy
Learn about Strategic Modeling concepts and how to integrate data between strategic models and planning applications using Groovy scripts.
Creating Groovy Templates
Create a Groovy template with interactive Design Time Prompts (DTPs).
The OBEs are available on the Help Center.



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).


Wednesday, February 27, 2019

New Row and Column Suppression Behavior for EPM Cloud!!

I am sure you will love this exciting new feature released in Smartview  11.1.2.5.720


This feature applies to these EPM Cloud services:
  • Oracle Planning and Budgeting Cloud
  • Oracle Enterprise Planning and Budgeting Cloud
  • Oracle Financial Consolidation and Close Cloud
  • Oracle Tax Reporting Cloud
In web applications, your administrator can use the Smart View Suppression Behavior option to change suppression behavior when both the Smart View No Data/Missing and Zero suppression options for rows, or columns, or both are selected.



Tuesday, January 29, 2019

Testing Network Throughput - Oracle PBCS!!!

Testing Network Throughput


I accidentally found this functionality thought it will be useful to share.

From the document, This topic does not apply to Oracle Cloud at Customer.

Using My services, you can test the end-to-end throughput of the network connection between the browser displaying the network throughput test page and the Oracle Cloud data center. Throughput is the average data rate attained for the transfer of an entire file.

The network test pings the Oracle Cloud data center multiple times with several predefined file sizes, and displays the throughput, latency, and response time. Throughput is expressed in megabits per second (Mbps); latency and response time are expressed in milliseconds (ms). If you contact Oracle for support about poor network performance while using Oracle Cloud, the support representative may ask for this data.