Archetype Blog

Discover Tips and Tricks To Make Collaboration Easier

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...

Hyperion Financial Management (HFM) Architecture

Whether you are in the process of selecting a tool for your organization’s consolidation and reporting needs, conceptualizing the application design for an in-progress implementation, or...

FDM / FDMEE Mapping: General Principles

Let's discuss the fundamental purpose of FDMEE mappings. FDMEE has come a long way since its origins and is at this stage is an ETL-like tool (Extract Transform Load). Mapping is the “T”,...

PBCS vs. EPBCS: 3 Factors to Consider

Ask anyone: it’s difficult to track all the latest technology updates. With new releases of PBCS (Oracle Planning and Budgeting Cloud Service) and EPBCS (Oracle Enterprise Planning and...