Tuesday, 27 May 2014

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

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