(1)Geographical Information System (BW 3.X) (2)Introduction & Overview Introduction & Overview Integration of IGS functionality into BW Integration of IGS functionality into BW Designing intuitive IGS applications with the Designing intuitive IGS applications with the BExBEx WebWeb Application Designer Application Designer Integrating geographical data into BW meta Integrating geographical data into BW meta-- & master& master data data Content Unit Title (3)Introduction & Overview Introduction & Overview Integration of IGS functionality into BW Integration of IGS functionality into BW Designing intuitive IGS applications with the Designing intuitive IGS applications with the BExBEx WebWeb Application Designer Application Designer Integrating geographical data into BW meta Integrating geographical data into BW meta-- & master& master data data Content Unit Title (4)Motivation Location Information everywhere Organizational structures of a company Legal entities, Subsidaries, (Sales) Districts/Regions, Profit Center, ... Company locations Offices, Stores, Warehouses, ... Customer and prospect locations Market data (e.g. D&B) and Demographics People are used to deal with geographic data Everyone knows geography from school Consume information via maps is normal (5)Combine the Benefits Vizualize geographic (location based) business data on maps Provide an easy and intuitive way to detect and analyze ... ... regional patterns (e.g. market trends) ... customer clustering Allow interactive information analysis on maps Select and filter (e.g. regions or customers) (6)Example: Regional Market Potential Analysis Task: Analyse the Market Potential in the States of the US Tabular display Map display Easy to understand Easy detection of regional patterns (7)Example: Regional Market Potential vs. Sales Task: Analyse Sales vs. Market Potential in the States of the US Map display Even complex tasks are easy to analyze (8)(9)Start Right Out of the Box Preconfigured Business Content Geo-enabled Meta Data Examples: Country, Region, BusinessPartner, ... Demo scenario Pre-configured Demo content Market Exploration scenario Sales data integrated with D&B Universe data Partnership with ESRI Worldwide maps for countries, regions and postal codes (US) ESRI ArcView to support geographic needs Creation of customer specific maps (e.g. Sales Regions) Geocoding BW customers get this for FREE! (10)BW, IGS & ESRI ArcIMS Using the Internet Graphics Service (IGS) the generation of analytical maps is available out of the box The IGS can optionally communicate with the Map Server from ESRI (ArcIMS) and can use it as a supplier of geographical data such as detailed street maps that automatically appear in the background of the analytical data. Interfaces from IGS can also be used to leverage geo services from ArcIMS; however, this requires project-specific developments. The following scenarios are conceivable beyond pure analytical mapping: Automatic geocoding of new customers in the call center Perimeter analyses using spatial queries for location searches Route planning or determining distances for optimization of routes (11)BW, IGS & ESRI: The BIG Picture A B C D E X Y Z Str eet ... City Lon gitu de Latitu de A ltitu de Internet Graphic Server (IGS) renders Charts & Maps ESRI ArcView generates BW 3.X ESRI Shapefiles Optional: Integration of ESRI ArcIMS via IGS (12)Introduction & Overview Introduction & Overview Integration of IGS functionality into BW Integration of IGS functionality into BW Designing intuitive IGS applications with the Designing intuitive IGS applications with the BExBEx WebWeb Application Designer Application Designer Integrating geographical data into BW meta Integrating geographical data into BW meta-- & master& master data data Content Unit Title (13)SAP BI Architecture GIS enabled InfoObjects with ESRI shapefiles Create Web Apps with Map Data Create Web Apps with Map Data Geo Coordinates (14)The Business Explorer Create BI Web Applications containing interactive maps Create BI Web Applications containing interactive maps (15)Web Application Designer Available Map Web item Multiple documents Map item properties Drag&Drop (16)Interactive Graphics: Maps Maps Full integration of interactive maps into Web Applications Map settings Available map renderers Color shading, dot density Bar charts, pie charts, split pies Symbols (Size and color graduated) Lines (Size and color graduated) Colors Legend Interactivity Adapted to available geo-characteristics Geographical interaction (17)Visual Analysis With Overlay Technique Customer Analysis Sales Analysis Market Potential Each layer can be represented by a different BW Query (18)(19)(20)(21)Introduction & Overview Introduction & Overview Integration of IGS functionality into BW Integration of IGS functionality into BW Designing intuitive IGS applications with the Designing intuitive IGS applications with the BExBEx WebWeb Application Designer Application Designer Integrating geographical data into BW meta Integrating geographical data into BW meta-- & master& master data data Content Unit Title (22)Extensions in BW Meta Data Repository Enable InfoObjects for geographic use Choose: static (shapes) or dynamic (points) Example: countries (static), customers (dynamic) Reflects frequency of change For static Geo-InfoObjects you can upload maps (shapefiles) Examples Country map (shapefile) for Americas US states map (shapefile) Maps (shapefiles) are stored in BW Server together with InfoObjects Single point of entry Guarantees transport (23)Extensions in BW Meta Data Repository 1. Enable InfoObject for geographic use (static or dynamic) 2. Upload or modify maps (shapefiles) for static (24)Mapping between BW data and maps USA Polygon Germany Polygon SAPBWKEY Country_Name Type United States US Germany DE Text Country BW Master data table Attribute file of country map Example: Country DE US (25)Master data enhancements Dynamic Geo-InfoObjects are enhanced with Geo-Attributes Geo-Attributes of location Longitude Latitude Altitude Attributes are (automatically) added when InfoObject is geoenabled (26)Master data enhancements with Geo-Attributes Geo-Attributes of customer locations (for dynamic InfoObjects) (27)Geocoding Geocoding in general Generate Geo-Coordinates for a location from a given address Examples Geocode customers, offices, plants, … Geocoding in BW A B C D E X Y Z Str eet ... City Lon gitu de Latitu de A ltitu de Download Master Data *.DBF 1 Upload as CSV-File 3 2 (28)Storage of Objects Store in BW All Shapefiles connected to data (Shapefiles should be less than 9MB) Store directly on IGS Shapefiles > 9MB Shapefiles not connected to data for cartographic backgrounds Images used for cartographic background Description Files for cartographic backgrounds Data Connection No data Connection Shapefile stored on IGS Defined as Cartographic Background Read more
