Forum Stats

  • 3,838,635 Users
  • 2,262,385 Discussions
  • 7,900,715 Comments

Discussions

Load YTD figures from PBCS BSO cube to HFM via FDMEE

IGM
IGM Member Posts: 20 Blue Ribbon
edited Oct 11, 2019 1:18PM in Financial Data Management

Hi,

I need to create an integration in FDMEE to copy data from a BSO cube (periodic data) in pBCS to HFM (YTD). The data needs to be extracted from PBCS as YTD. And this is the thing that I am struggling with. I have tried referencing dynamic time series in FDM but this turned out to be too slow.

Can someone suggest a better solution?

Kind regards,

Tagged:

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Sep 20, 2019 2:24PM

    Why don't you load the data as periodic to HFM and use native functionality to return YTD.

    Cheers

    John

  • MarkHaddad2
    MarkHaddad2 Member Posts: 3
    edited Oct 11, 2019 1:18PM

    From a pure solution perspective. You could create a YTD scenario and have a business rule run to populate the YTD scenario.

    If this is actual data you may want to revisit this process, it would not be typical to load actual to pbcs prior to hfm. If HFM is consolidating YTD it is typically simple enough and recommended to get YTD data from the source ERP system.

    Hope this helps,

    Mark