Negative forecasts are forcefully set to zero after the reconciliation step in SAS Forecast Analyst Workbench. This means that reconciliation happens with negative values. If there is a negative forecast in a leaf level, then the reconciliation step is executed with negative values. After reconciliation the negative values are set to zero and then displayed in the user interface. In Collaboration Workspace, zero forecast values for leaf level are considered for aggregation to higher level. This issue can cause data in SAS Forecast Analyst Workbench to not match up with SAS^® Forecast Server.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After the fix is available, a new column called ALLOW_NEGATIVE_IND is available in the KPI_CONFIG table. This column indicates whether negative forecasts are allowed or set to zero.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Forecast Analyst Workbench	Microsoft® Windows® for x64	9.4 TS1M3
		64-bit Enabled AIX	9.4 TS1M3
		Linux for x64	9.4 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

A fix for this issue for SAS Forecast Analyst Workbench 5.3 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/A2D.html#58828

---

In SAS® Forecast Analyst Workbench negative values are set to zero. When using Collaboration Workspace, zero forecast values are considered for aggregation to higher level causing a data discrepancy.

Type:	Problem Note
Priority:	high

Date Modified:	2016-12-02 09:36:37
Date Created:	2016-08-19 15:03:49