RouteOne case study
Transferring order and sales statistics into an Excel spreadsheet.
Business requirement
A retail company requires order and sales statistics on a daily basis for the managing, financial and sales directors. These are required in an Excel spreadsheet where profit margins are analysed.
Using RouteOne
- A definition is created on the iSeries to extract the order and sales data
- An FTP request is created that specifies the email recipients and the Excel format.
- An Excel macro is specified to automatically perform calculations before the workbook is emailed
- The RouteOne job is added to the IBM scheduler to run automatically as often as required
- RouteOne command also included as an icon on the desktop
Benefits of using RouteOne
- The directors receive the information automatically via e-mail as often as they require
- No intervention is needed once the request has been set up
Back to RouteOne case studies
