For his European reporting a manufacturer of electronics equipment wants to receive the sales figures of the previous week every Monday morning from his branch offices as an excel file.
As many figures of the previous week are not provided before Monday morning, it has to be ensured that the sales figures having to be sent are complete.
The sales figures have to be sent promptly, after the branch office has been provided with the sales figures by his distributors.
Our DWH builder sends the data per excel to a FTP server of the manufacturer. In order to ensure that the data are complete, this job does not run before all the data of the distributors have been imported. This can very easily be adjusted with the help of our DWH builder, fully-customizable.