Here we are showing you nice features about the DWH Builder
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.
Let’s have an example with a Date, a Number and a Currency. Well formatted…
But in fact we are allowed to input whatever we want…
Even the format has not been changed.
In the DWH Builder it looks like this
All columns are Character Fields because the first 20 rows are taken to check for the format is and how the corresponding values are.
The format here is different to the content of the columns so that Character will be taken. And the Row with the “wrong” values will be shown.
Let us change the Excel File and do the first 20 Rows correctly
How about the DWH Builder?
Now the DWH Builder recognizes that these Columns are datetime and float. (Dataytpe Currency will be converted to float in the DWH Builder)
And the Row with the wrong values will be omitted.
Every morning many reports have to be sent via e-mail to other users, be it as an excel file, a pdf file or whatever. The difficulty is that these reports have to show current data and can therefore be provided not before a great many of data have been uploaded into data warehouse. Solve this difficulty with the help of our DWH Designer: after the download of the data it will automatically compile a report and send it.
Our DWH reliably uploads data from native navision systems into the data warehouse. The transformations of the different data types are effected quickly and accurately regardless of the peculiarities the native navision has.
Contact – Get in touch with Wilcon Data
Wilcon Data GmbH
41468 Neuss, Germany
Tel.: +49 2131 316493-0