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.

...Restatements

One of the topics that I have spent time on is to understand the most efficient way to restate reported data in HFM. On one side, ...