More Thoughts on Essbase Hybrid Aggregation

I’d like to add to the emerging Essbase Hybrid Aggregation knowledge base with a few clarifications, gleaned from testing in active projects. The motivation for me came from my investigation into the feasibility of using a hybrid approach for an application with a lot of heavy allocations done in business rules. I had read that…

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

Simple Connected Automation in the Cloud

Oracle’s Planning & Budgeting Cloud Service (PBCS) and it’s sibling Enterprise PBCS includes many great built-in administrative features.   You can manage just about all facets of the normal care & feeding of planning and reporting applications without leaving the application interface – even scheduling logic such as data & dimension loads, business rules, and data…

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