Forum Discussion

GedS1's avatar
GedS1
New Contributor II
3 years ago

Actuals not replacing Forecast months entirely

Hi all,

We currently have an issue whereby when we seed our Actuals data to our Forecast scenario we have set up, the Actuals do not overwrite everything as we would expect in that particular month. So for example, some of the forecasted data we loaded via forms in previous months is not being overwritten once the Actuals are imported. So we're having to cleanse the forecasted data in the affected months which is quite time consuming.

Does anyone know what might be causing this issue?

Thanks,

Ged

Data Integration
Data Management
Data Sources
Import
  • TonyToniTone's avatar
    TonyToniTone
    Contributor II
    3 years ago

    Tough to say from this information without digging into this in more detail.  Sounds like this could be related to the overall process or the process of seeding Actuals to Forecast ( i.e. data copy through DM or seeding from a Business Rule ) after data is already submitted in Forecast Scenario.  If using a Business Rule to seed, there may be something in the formula that needs to be addressed.  I would suggest submitting a support ticket and spending time with AAS to review this entire process.  

    • ChristianW's avatar
      ChristianW
      Valued Contributor
      3 years ago

      If you use a business rule for the copy and if the forecast is loaded and/or manual input, then you need to actively delete the data before the override. The clear function can’t easily delete data that isn‘t calculated (but there is an answered OneComunity question discussing the topic).