Guide for forecast through the Reporting Tool
Article ID: 239720
Updated On:
Products
Issue/Introduction
This knowledge article is to be used as a basic guide for running forecasts through the reporting tool utility. Sometimes the forecast tool in Process Monitoring is not enough or the forecast needs to be sent via email.
Resolution
There are two steps to the reporting tool. The reporting tool gui and the command line tool. A pre-requisite is that the autoforecast has been run in the client the tool will be run against. In this case it's client 100.
Reporting Tool GUI (setting up the query)
- (Windows only) Run the ucyrepg.jar executable from the utility/bin directory
- Right-click on Forecast and choose "New Query..."
- Give the report a name that makes sense, input a client, and make sure the correct From and Until info is input and click Next
- Select which fields should be used in the report (Please note: Only some are allowed for forecast reports) and click Next
- Add selection criteria as needed/wanted and click Next
- On the Output settings page, be sure and update the file name and max number of rows as needed and click Finish
The above steps created a file in the utility /bin/queries folder with the name specified in step 3 above - in this example, the file is AUTOFORECAST_14_DAY.f.xml
Reporting Command Line Tool
To run the command line tool the correct start parameters will be needed. A full list can be found here
- Open the windows command line
- cd to the utility/bin directory
- Run the command for ucybdbrt.exe based on the start parameters from above. In this example, only -X pointing to the .xml file in the queries directory is needed
- Let the command finish
- There should now be an output file based on the definition from the reporting tool section above. In this example, it's output.html which is by default put into the utility/bin directory
Additional Information
Feedback
