Downloading BI Master Data into a dBase File 

Use

The first step in SAPBWKEY maintenance for dynamic geo-characteristics and their geocoding is to download the BI master data table into a dBase file.

Procedure

...

       1.      Log on to the BI system and go to the InfoObject maintenance screen (transaction RSD1). The Edit InfoObjects: Start dialog box appears.

       2.      In the InfoObject field, enter the name of the dynamic geo-characteristic that you want to geocode (in this example: 0D_SOLD_TO).

       3.      Choose Display. The Display Characteristic 0D_SOLD_TO: Detail dialog box appears.

       4.      Choose the Business Explorer tab page. In the BEx Map area, 0DSOLD_TO is displayed as a Dynamic Geo-Characteristic.

       5.      Choose Geo Data Download (All).

If you only want to maintain those entries that have been changed since the last attribute master data upload, choose Geo Data Download (Delta). The geo-data has to be downloaded in the delta version before you execute the realignment run for the InfoObject. Otherwise the delta information is lost.

       6.      The system asks you to select a geo-attribute that you want to include in the dBase file. The system only displays those attributes that were defined as geo-relevant. In this case, select both attributes: 0D_COUNTRY and 0D_REGION.

       7.      Choose Transfer Selections.

       8.      Transfer the file name suggested by the system and choose Transfer.

The proposed file name is made up of the technical name of the characteristic and the .dbf extension. You can change the file name and create a directory. If you do not specify a path, the file is automatically saved in the SAP work directory.

Result

The status bar contains information on how much data has been transferred.