My Oracle Support Banner

How to Perform Data Load in Essbase Cube Through EFPA via OFSAA Batch? (Doc ID 2446578.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Oracle Financial Services Enterprise Performance Management (EPM)


Question 1: There is requirement to load data in Essbase cube through EFPA for a specific period (i.e. May-2018).

Is it possible to load the data through OFSAA batch? If possible, how is this done?


Question 2: EFPA User Guide says:

"Load the data to the cube. This is performed by the CREATE CUBE task within the Batch definition. Data load has to happen in sequential order for the months for which data is available in fact tables."

However, business requirement is for data load to happen as per their input Period parameter. A job that will refresh the entire cube will also be needed.

How to customize the batch such that it will take the required user input parameters.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.