Jerry Yin

Blogs from this Author

Patient Files Are So Old Fashioned

CPM Data File Batch Functionality

Both OneStream and Oracle EPM cloud provide the data file batch functionality to load the data.  The common ground is that they both need a specific file name format, others are different.   For OneStream, here are the steps: Create batch processing extender business rule. Batch file processing is executed by creating an Extender Business […]

data tables on computer

Multi-Year Multi-Period Data Load

Sometimes we need to load multiple years and periods of data planning or Essbase, like a business plan or forecast data. Data Management/FDMEE provides the different options for loading multiple years and periods data from the file, depending on the different file formats. If data is in a single column and both Year and Period […]

Data Business Computer People

Journal in OneStream

Traditionally, you use journal for consolidation. In OneStream,  you can use journal to load data to “AdjInput” in “Origin” dimension, not only for consolidation cube, also for planning or reporting type cube. Journal or journal template in OneStream have many settings to meet different requirements. For example, you can choose “Balanced” or “UnBalanced” for “Journal […]

Andes Blog 600x400

Use FDM to FDMEE Migration Utility

There are basically 2 options when upgrading FDM classic to FDMEE: rebuild all artifacts, or use FDM to FDMEE migration utility to migrate some, then build the rest.  FDM to FDMEE migration utility is a helpful tool but it has its limitation, for example, the utility can not translate script from VB script to Jython. […]

Late Afternoon Toned Photo Of California Farm With Irrigation

How to Create a FDMEE Report in 11 Steps

FDMEE reports provide a solution that incorporates the source and target data, templates, and user-defined SQL queries. Templates, created in Oracle Business Intelligence Publisher, consume data in XML format and generate reports dynamically. SQL queries can be created to extract data from FDMEE internal tables and coupled with report parameters to extend the definition of […]

Configure Oracle HCM Cloud as Source for EPBCS – Part 2

In Part 1 of this blog post series, we covered the standard process to create, configure, and initialize Oracle HCM Cloud as a source application for Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS). In Part 2, we’ll address the steps to take when the EPBCS application has customized dimensions. There is no Oracle documentation about […]

Configure Oracle HCM Cloud as Source for EPBCS – Part 1

Oracle Human Capital Management (HCM) Cloud can be configured to be a Data Management source system as type “Oracle HCM Cloud.” This integration provides the user with an easy way to integrate data from the Oracle HCM Cloud application into the Workforce Planning or Strategic Workforce Planning application without using flat files in the middle.  […]

FDMEE – Use Scenario as a Generic Dimension Class

In Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE), when you setup a target application, a target dimension class needs to be specified for each dimension. Target dimension class is a property that is defined by dimension type. For example, if you have Period dimension, the dimension class is “Period”; for Account dimension, dimension […]