- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Loading YTD data from Planning to HFM
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 18.104.22.168
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!