Archetype Blog

Discover Tips and Tricks To Make Collaboration Easier

Using FDMEE Multi Dimension Mapping

In old FDM if there was ever a need to source two fields for an exception mapping, it was required to write a script to resolve this issue so that the scripted member would then be able to...

Automating Calc Manager Rules for Oracle Hyperion Planning

Oracle’s Calculation Manager has a host of features for creating business rules across the Hyperion suite of products. Today I want to focus on how to automate those rules in a Hyperion...

FDMEE / FDM - Map One Source Account to Multiple Target Accounts

What do you do when one line item provides more information than only one destination Point of View?

Using Batch & MaxL Scripts to Build a Simple Data Utility

Introduction

Loading data to Essbase cubes can be done in many ways. Oracle provides a number of applications that can perform this task. One of such tools is MaxL. Combining Maxl Scripts...

Copying ODI Studio Connections Definitions

Technology: Oracle Data Integrator(ODI) Studio

Version: 11.1.1.6x

On-Premise to Cloud FDMEE Integration

At a recent engagement, we needed to load Actuals from a Hyperion Financial Management (HFM) application to a new Oracle Planning and Budgeting Cloud Service (PBCS) application. Oracle had...

FCCS & HFM: Similarities & Differences

With the release of FCCS, Oracle has shifted focus from its on premise-based consolidation solution, HFM, to a cloud-focused solution. FCCS isn’t quite “HFM in the cloud”, however, it is a...

Reconciling Data: What is the Best Approach?

Most organizations severely underestimate what it takes to reconcile data. They often don’t consider how much historical data is needed and other items that need to be accounted for. The...

March Madness: The Data Behind the Chalk

There’s an old joke among hikers: If a bear attacks your group, you don’t need to outrun the bear, you just need to outrun your slowest friend. However morbid, the lesson is a valuable one...