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