Skip to Content

Forecast or Recalculation of Forecast in the Past Planning Service Takes Long time

Forecast Planning service takes long time due to huge entries in change history table entries in the time series.

Forecast Planning services: SPP: Forecast Service -  SPP_FCS_SERVICE, SPP: Forecast Disaggregation Service -  SPP_FCST_DISAGGREGATION, SPP: Forecast Service (StdDev.) - SPP_FCS_SERVICE_MSE, SPP: Forecast Approval -  SPP_FCST_RELEASE.

Below Changed history tables in time series data area have Millions of records.

It leads to poor performance in the forecast planning service.

/SCA/TK1SPM  -  Key Figures of Time Series Data Area 1SPM

/SCA/TS1SPM - Status Values of Time Series Data Area 1SPM

/SCA/TN1SPM - Notes for Time Series Data Area 1SPM

/SCA/KT1SPM  - Key Figure History for Time Series Data Area 1SPM

/SCA/ST1SPM  - Status History for Time Series Data Area 1SPM

/SCA/IS1SPM  - Internal Status of Time Series Data Area 1SPM

Delete all change History for times series data area which will improve performance.

You can use below reports to delete time series change history entries.

Report /SCA/TSDM_TS_HIST_DELETE - Delete time series change history

Report /SCA/TSDM_TS_HIST_DELETE_ALL - Delete All Time Series Change History Entries

Former Member

No comments