...FDM reclassifications with logic accounts

I was recently discussing (with my wife) about the various HFM reclassification journals (VAT, Corporate tax, Cash/Overdraft) and it occurred to me that the easiest way to complete this task is with the proper configuration and design of the FDM application.

Proem

When designing an FDM – HFM solution, my understanding is that FDM should be used to replace all the manual, time consuming, non-value-added data-management steps of the ETL process while moving data from the ERP to HFM.

This design has 2 main guidelines:

• The extract query from the ERP system should not exclude any of the data. The main reason of this guideline is to prevent the exclusion of any future ERP changes to be extracted in the extract file.

...Keep calm and Hyperion a lot!!!!

Hi all,

This is not a usual post with one of my experiences or a thought that I had recently... enjoy and share!!!

... configuring an HFM environment

One really interested task that is a crucial phase of a project and I would like to share a summary of my experience is the configuration of an Oracle HFM environment.  Before going further, I would like to clarify that I am not an expert on that field but I will do my best to describe it...

Proem

As it happens in every project after the receipt of the new environment from the OS team, the implementation team will install and configure all the Hyperion components. Based on the great improvements of Hyperion v11.1.2.3 (11.1.2.4 is out but not in production yet so…), the installation is a really quick task contrary to the configuration of the environment which needs a lot of study, preparation and communication with the different infra teams of the customer.

Main

For me the best way to discuss about configuration is

...the Hyperion Administrator

Hi all,

1. Proem
I have not posted anything for the past few months because I was just gathering experiences (sounds heroic, right?) and I also got married (yeah!!!).

One of the experiences that I had was to document the roles of a new team and I ended up with a lot of questions to answer.

A few months after having completed this task I would like to touch a really sensitive issue which creates great discussions among the Hyperion professionals.  

         Who can we call Hyperion Administrator?

Is it the person who focuses on the management of the Hyperion infrastructure, the person who focuses on design and building the applciation, the person who focuses on business requirements or the person who can assist the Hyperion users and answer the more complex questions?

2. The answer
For me is the person who

...work in progress and a great distance to be covered

It was a long 7-months journey with passion for two new HFM applications, hard lessons from organising projects and great experiences with managing teams... are we going to be winners?

See you around,

Thanos

..synchronising HFM applications

Hi all,
 

It’s been a long time since my last post but I am in the middle of 3 different projects and blogging is not one of the priorities. However, I spend a lot of time on OTN Financial consolidation space.

    1. Proem

The topic of post today will be the data synchronisation of two HFM applications with the use of the rule file.

To give you a bit of background, during an Oracle training for the HTP application, one of the interesting topics that we discussed was how to keep the data of the HTP application in sync with the data of the statutory application. The solutions offered were:

• Use of FDM.
• Use of Data synchronisation (if the application are EPMA).
• Manually extract and load data.
• Use of the rule file 

    2. Approach

Since more or less all the rules have a VB code to write to text file the debugging logs during the calculation of the data, we will use the same approach to extract the data from the source application and load the data to the target application.

..delays

Initially, I had in mind to write an analysis related to the HFM application settings. However, after such a huge delay, I think that I should describe what I experienced the first 3 months of 2014.

    1. Proem

So, 2013 left our lived a few months ago and 2014 came in. Santa Clause did his annual job and brought a lot of lovely presents and Oracle teams did their job and brought HFM version11.1.2.3, FDMEE and a whole set of new features which will improve our applications.

    2. Installation of version 11.1.2.3+