Because life has many aspects but the truth is always one…
Wednesday, 12 August 2015
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.
Subscribe to:
Posts (Atom)
...using SmartView
Last week I was chatting with an ex-colleagues about our HFM experiences. After 10 years, we both have a lot of stories to share but a...
-
Hi all, In 2008, I was asked to train the admin users of a financial group and explain them how their future application will work. E...
-
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...
-
Recently (July 2017), I discovered a new functionality of OneDrive which allows multiple users to work on the same file concurrently a...