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

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

Passing Variables to Essbase Calc Scripts from FDMEE

Those of us that have extensive experience building FDQM integrations have long used either the event scripts or customization within the load action in the FDQM workbench in order to execute standard and/or variablized essbase calculation scripts. This almost always got the job done, but was not easy. Fast-forward to the current era of FDMEE,…

Read More