Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading YTD data from Planning to HFM

MikkisNov 16 2018 — edited Nov 21 2018

Has anyone loaded Dynamic YTD (eg. JanYTD instead of Jan) Budget values from Planning application as source to HFM applicaiton as target using FDMEE. We are in 11.1.2.4

We tried to load Periodic but it is causing variances as certain months have no data in Planning and HFM is backing out prior month periodic to make YTD as 0 instead of loading zeros. We cannot load zeros in periodic as we can't create zeros in Essbase and FDMEE is set to skip zeros for Actuals.

Edit: We do have zeros in months in Essbase. So I guess that makes it easier. I might look into changing the setting to Skip Zeros to No for this location when loading Budget. Trying to use NZP along with Periodic data and see if that works

Let me know if there is better way than this.

Thanks in advance!

Mikkis

Added on Nov 16 2018

#business-intelligence-applications, #financial-data-management, #hfm, #performance-management-applications, #planning

6 comments

603 views