Prefixed Target Applications in FDMEE

In earlier versions of FDMEE/FDM, you could not setup multiple instances of the same target application.  Locations in the same application in FDM that existed on a lagged calendar had to be loaded to different months than locations with a non-lagged calendar.  Starting in version 11.1.2.4.220, a new feature was introduced to allow duplicate target…

Read More

Excel Template Loads with FDMEE

Within 11.1.2.1 FDM, users were able to complete full financial statement loads using a workbook with multiple sheets.  Unfortunately, when upgrading to 11.1.2.4 FDMEE, the workbooks issued a multitude of errors when attempting to run the FDMEE Import Data step!   The answer from Oracle was that the workbook template functionality was fully supported and should…

Read More

Smart Forms for Client-Side Calculations

The Excel formulas and functions that you add to ad hoc grids in Oracle Smart View for Office can now be saved as planning artifacts called “Smart Forms”. Note:  Smart Form functionality is available for ad hoc grids created from several of Oracle’s Cloud Service offerings, including Planning and Budgeting Cloud Service. Check with your…

Read More

FDMEE Multi-Dimension Mapping

In FDMEE the mapping functionality is a fundamental purpose of the tool. Member mappings act as the middle man between Source members and Target members within a given dimension.  A simple example of this would be if your general ledger Source Account "300999" (Sales Returns) needs to load to account "300995" (Returns) in your EPM…

Read More

Variablizing the Left Side of the Equation with @XWRITE

A common need in an Essbase calc script is to map values from one dimension to another. For example, let’s say you have accounts that you want to map to entities. You load values into those accounts at ‘Main Entity’, and then need to assign each account to its own unique entity. Dimensions: Account  …

Read More