As this question came in a recent support ticket, here's how to produce a Forecast report with the DB reporting tool:
Pre-requisite: the
AutoForecast must have been configured and executed at least once in the AE system.
Set the key
'AUTO_FORECAST_PREFIX' in
UC_CLIENT_SETTINGS.
Open an
window:
https://us.v-cdn.net/5019921/uploads/editor/x6/u64nx806q721.png" width="1021">
Select the object types, Agent types and period for which the forecast should be executed, then press 'Recalculate' (this will create the
UC_AUTO_FORECAST variable if it did not already exist), then 'Execute Query'.
You will then get a list of planned tasks for the defined period:
https://us.v-cdn.net/5019921/uploads/editor/u8/sa7ia99lih25.png" width="722">
Once the autoforecast has succesfully run you may create a 'Forecast' query using the Reporting Tool:
https://us.v-cdn.net/5019921/uploads/editor/wz/omzzig64eacl.png" width="320">
Steps to generate the report are then similar to those described in the first message above.
Best regards,
Antoine