Skip to main content
Solved

Deleting/Cleansing old collaborative forecasts

  • July 23, 2020
  • 1 reply
  • 121 views
G
Do Gooder
Forum|alt.badge.img+5

Hi folks,

 

I’m running into a weird situation where old collaborative forecasts from the Demand Client can’t be deleted. I’ve tried to delete trolleys, unpublish to specifics folks in IEE, nothing seems to work.  Moreover, I can’t seem to find documentation on how it’s supposed to work - for whatever reason, I recall that running “create forecasts” on the Demand Server should cleanse old collaborative forecasts….but that doesn’t seem to be what’s happening.  Am I off base in my memory? Is there a way to force a refresh/deletion of collaborative forecasts?

 

Best answer by ghdp

A solution for the board:

 

At one point, create forecasts did indeed erase the collaborative forecast.  However, that’s no longer the case. Collab forecasts stick around and have to be cleansed from the table manually.

 

If you are seeking to cleanse it, contact IFS support or, at your own risk:

“The field COLLABORATE_FORECAST must be altered to the wanted starting value. Equal to the adjusted forecast or to 0 for example, system forecast is not possible since the values are not in the database

Deleting the contents will not work I believe.
Looks like a data repair to find the collaborations and set them = 0 for example.  Don’t delete the records in the table - simply update them.

View original
Did this topic help you find an answer to your question?

G
Do Gooder
Forum|alt.badge.img+5
  • ghdp
  • Do Gooder
  • August 17, 2020

A solution for the board:

 

At one point, create forecasts did indeed erase the collaborative forecast.  However, that’s no longer the case. Collab forecasts stick around and have to be cleansed from the table manually.

 

If you are seeking to cleanse it, contact IFS support or, at your own risk:

“The field COLLABORATE_FORECAST must be altered to the wanted starting value. Equal to the adjusted forecast or to 0 for example, system forecast is not possible since the values are not in the database

Deleting the contents will not work I believe.
Looks like a data repair to find the collaborations and set them = 0 for example.  Don’t delete the records in the table - simply update them.

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings