Wednesday, 12 August 2015

...a big thank you to all my colleagues

As a last post from my current role, I would like to say a big thank you to all my colleagues for being so supportive, patient and open to my ideas for the last two years and especially during the Hyperion upgrade project.



See you soon!!!!

Thanos

Sunday, 2 August 2015

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

...Records & Subcubes in HFM

A few years ago, I decided to spend time to understand how HFM calculation engine works with aim to improve the performance of the r...