BEx Map in SAP Business Warehouse Concept Continued

BEx Map in SAP Business Warehouse Concept is discussed in the previous post and here is the continuation for that discussion. To be able to maintain the SAPBWKEY, you have to load the three files for the shape file to your local hard drive. However, you can only maintain the SAPBWKEY in the dbf file. You can maintain the SAPBWKEY in Excel or in ArcView - it is recommended that you use Excel for small amounts of data, since it is easy to operate.

Creating a Static Geo-Characteristic

Select the InfoObject in the InfoObject maintenance of the Administrator Workbench that you want to display as a static geo-characteristic. Open the "Business Explorer" tabstrip and choose the entry "Static Geo-Characteristic" from the drop-down menu (1). Before you can maintain the SAPBWKEY, you need the geographical data for the InfoObject. Load this to your local PC by choosing the button "Download Geo-Data" (2): Download Geo-Data (Everything) - if you want to maintain the SAPBWKEY with the InfoObject data for the first time. Download Geo-Data (Delta) - if you want to maintain the SAPBWKEY for new, additional master data in BW.

Exporting Master Data for Geo-Characteristics

Confirm with Transfer.

Maintaining SAPBWKEY with Excel

You usually copy the shape file from the relevant CD that you receive when you buy BW. In the course, however, because we are working in a training system, you use a different procedure (you load the shape file from the SAP Office folder) - your trainer will give you more precise information. You load the three files for the shape file from your local hard drive into the directory, into which you saved the geographical data for your geo-characteristic (usually SAPWorkDir).

In Excel, open the file with the geographical data for the geo-characteristic and the dbf file for the shape file Transfer the SAPBWKEY from the geo-characteristic file into the relevant column of the dbf file for the shape file.Do not change the order of the rows in the dbf file for the shape file when you are maintaining the SAPBWKEY in Excel! If you do this, it is no longer possible to correctly assign the geo-data to the polygon from the map. Save your entries and close the file.

Loading the Files for the Shape File

In the next step, you load the three files for the shape file into the BW Business Document Service,so that you can access the files when you execute a query with a map attached. In the InfoObject  directory in the AWB, choose the InfoObject that you defined as a geocharacteristic.On the tab page "Business Explorer" click on the button "Upload Shape Files". For each of the three files you get a separate dialog box, in which you confirm the loading process. Now you can use the geo-characteristic in a query definition and display it on a map. Using the "Edit Shape Files" function, you can view and edit the three files for the shape file in BDS.

Using Dynamic Geo-Characteristics in BW

If you want to use a dynamic geo-characteristic (to display isolated information on a map), you have
to use ArcView to geocode the characteristic. ArcView is GIS desktop software that offers extensive geographical functions. You receive ArcView when you buy BW. The following slides give a short overview of the geocoding procedure.

Maintaining Dynamic Geo-Characteristics

If you define an InfoObject (on the tabstrip "Business Explorer" in the InfoObject maintenance) as a dynamic geo-characteristic, the three attributes - geographic height, length and width - are automatically created for your InfoObject. You load this attribute in the form of a dbf file in ArcView and then geocode; that is, you attach real geographical coordinates to the corresponding geo-attributes for the InfoObject. You then load this data to your BW in the form of a csv file. The loading process is the same as loading data from a flat file into BW and uses an InfoSource that you have specified for it. 

SAP BW LO Data Extraction Continued
Data Extraction from Finance Special Ledger using ...
SAP Business Process Delta Process
Extraction from CO and PA using SAP BW Part Three
SAP Business warehouse Tools for Generic Data Extr...