You have completed the following steps:
Downloading BW Master Data into a dBase File
Integration
As a result of the geocoding, you receive the dBase file Geocoding_Result.dbf. This file contains the BI master data enhanced by the columns X and Y. Since the attribute table is saved in dBase file format, you now have to convert the table into a CSV ( c omma s eparated v alue) format that can be executed by the BW Staging Engine. You can convert the table in Microsoft Excel.
Launch Microsoft Excel and choose
...From the selection list in the field Files of Type, choose dBase Files (*.dbf).
Open the file Geocoding_Result.dbf. The attribute table with the geo-attributes is displayed in Excel.
Choose
...From the Save as Type selection list, choose CSV (Comma Delimited).
Save the table.
You have converted the dBase file into a CSV file with the geo-attribute for the dynamic geo-characteristic 0D_SOLD_TO. You system administrator can now schedule a master data upload.
When you upload the CSV file, you have to map the values in column X to the attribute 0LONGITUDE, and the values in column Y to the attribute 0LATITUDE.