Load YTD figures from PBCS BSO cube to HFM via FDMEE

IGM Sep 20, 2019 2:44 PM

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,

1. Re: Load YTD figures from PBCS BSO cube to HFM via FDMEE

JohnGoodwin Sep 20, 2019 6:24 PM (in response to IGM)

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

Cheers

John
Like Show 0 Likes(0)

Actions
2. Re: Load YTD figures from PBCS BSO cube to HFM via FDMEE

MarkHaddad2 Oct 11, 2019 5:18 PM (in response to IGM)

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
Like Show 0 Likes(0)

Actions

Go to original post