BW and BW Reporting Introduduction UNWBW 1 – Business Information Warehouse Net. Weaver Support Consultant Training
Content n Introduction n Reporting n Business content n Data loading n Info. Cube Design n Aggregates n BW-BPS Business Planning & Simulation n Monitoring & Technical Risks ã SAP AG 2004, Business Information Warehouse / 2
SAP Net. Weaver in Detail SAP Mobile Infrastructure n Tight coupling and alignment with SAP business solutions SAP Net. Weaver™ People Integration SAP Enterprise Portal n Business content n Open architecture (Crystal, Ascential) Master Data Management SAP Exchange Infrastructure n Cross-component business processes n Shared integration knowledge SAP Web Application Server n Proven, scalable, comprehensive toolsets n Leverage existing infrastructure/skillsets ã SAP AG 2004, Business Information Warehouse / 3 Portal Collaboration Information Integration Business Intelligence Knowledge Management Master Data Management Process Integration Broker Business Process Management Application Platform J 2 EE ABAP DB and OS Abstraction Life Cycle Management SAP Business Information Warehouse Multi-Channel Access Composite Application Framework n Business packages n Collaboration
Information-Based Management How do we get from here. . . Data Information to here? Knowledge Results Realizing business value from transaction data ã SAP AG 2004, Business Information Warehouse / 4
Data Warehouse Definitions l A collection of integrated, subject-oriented databases designed to support the DSS (Decision Support System) function, where each unit of data is relevant to some moment in time. W. H. Inmon, “Building the Data Warehouse, ” 1996, page 371 l A copy of transaction data specifically structured for query and analysis. R. Kimball, “The Data Warehouse Toolkit, ” 1996, page 310 ã SAP AG 2004, Business Information Warehouse / 5
Data Warehouse Objectives l Standardized structures and representation for all enterprise information l Easy-to-use access, single-point of access to all enterprise information l Self-service, high quality business reporting and analysis on all levels l Fast and cost-effective to deploy l High performance environment fed from heterogeneous sources l Freed-up systems and IT resources in OLTP environment ã SAP AG 2004, Business Information Warehouse / 6
SAP Business Information Warehouse l Data Warehouse system with optimized structures for reporting and analysis l OLAP engine and tools l Integrated meta data repository l Data extraction and data staging n Preconfigured support for data sources from R/3 Systems n BAPIs for data sources from non-SAP systems l Automated Data Warehouse management l Administrator Workbench for controlling and managing content l Only one productive client ã SAP AG 2004, Business Information Warehouse / 7
Business Information Warehouse: Architecture Business Explorer Web Reporting 3 rd Party Tools client BAPI Administrator Workbench OLAP processor Meta Data Repository Info. Cubes ODS Staging Engine Info. Object BAPI Data Sources ã SAP AG 2004, Business Information Warehouse / 8 Business Information Warehouse Server
OLTP versus OLAP Characteristics OLTP OLAP Primary Operation Analyze Level of Analysis Low High Amount of data per transaction Very small Very large Type of data Detailed Summary Timeliness of data Must be current Current and historical Updates to data Frequently Less frequent, new data only Number of transactions/users Many (100 s to 1000 s) Few Response time Quick Reasonable Database data Normalized Denormalized Type of processing ã Update Well defined Ad hoc SAP AG 2004, Business Information Warehouse / 9
Administrator Workbench (RSA 1) Purpose The Administrator Workbench is the tool for controlling, monitoring, and maintaining all of the processes connected with data staging and processing in the Business Information Warehouse. Integration The data for the SAP Business Information Warehouse that has been staged with the help of the Administrator Workbench can be evaluated and presented with the Business Explorer reporting tool. Functions The Administrator Workbench encompasses the following functional areas: · Metadata Repository · Installing Business Content · Modeling · Administration · Reporting Agent · Documents · Translating Texts for BW Objects ã SAP AG 2004, Business Information Warehouse / 10
What is an Info. Object ? The various OLTP data models are unified for BW Business objects / table fields become Info. Objects R/3 OLTP CO Table of cost centers Controlling Info. Object “ 0 COSTCENTER” HR Table of employees Human Resources ã SAP AG 2004, Business Information Warehouse / 11 Info. Objects are unique across application components !
Types of Info. Objects l Characteristics: evaluation groups like “Cost Center”, “Product group”, “Material” n Have discrete values stored in their master data tables (e. g. the characteristic “Region” has the values “North”, “South”, . . . ) n Special types of characteristics: w w Time characteristics like “Fiscal period”, “Calendar year” Unit characteristics which comprise currencies and units of measure like “Local currency” l Key figures: continuously valued numerical fields like amounts and quantities (e. g. : “Revenue” and “Sales quantity”) ã SAP AG 2004, Business Information Warehouse / 12
Master Data tables for Characteristics Information about characteristics is stored in Master Data Tables: n Attribute Tables u Dependent attributes of a characteristic can be stored in an Attribute Table for the characteristic. n Text Tables u Textual descriptions of a characteristic are stored in a separate text table. n External Hierarchy Tables u ã Hierarchies of characteristics or attributes may be stored in separate hierarchy tables. SAP AG 2004, Business Information Warehouse / 13 Material Attribute Table MATERIAL_ID Material Group Material Type Material Text Table MATERIAL_ID Material Name Material Hierarchy
Info. Cube l Central data store for reports and evaluations l Contains two types of data n Key figures n Characteristics l 2 fact tables and 16 dimension tables n 3 Dimensions are predefined by SAP w w w ã Time Unit Packet SAP AG 2004, Business Information Warehouse / 14
South Customer group Dept. Stores North Region East Info. Cube: Example Wholesale Retail Glass- Ceramics Plastics Pottery Copper Pewter ware Division ã SAP AG 2004, Business Information Warehouse / 15
Info. Cube: Multi-dimensional analysis Info. Cube 2 Analysis Glass- Ceramics Plastics ware Division ã SAP AG 2004, Business Information Warehouse / 16 East of Plastics division and Southern region Customer group South North Dept. Stores Wholesale Retail Region South East of Plastics division Customer group North Region of Ceramics division 3 Analysis Glass- Ceramics Plastics ware Division Dept. Stores Wholesale Retail East 1 Analysis Customer group South Division North Glass- Ceramics Plastics ware Dept. Stores Wholesale Retail Region East Product group Customer group Division Area Company code Region Period Profit Center Bus. Area Customer group South North Region Characteristics: Glass- Ceramics Plastics ware Division Dept. Stores Wholesale Retail
Operational Data Store The BW ODS-Object: Stores transaction data Is a denormalized data structure n Transparent table n Not a star schema Can hold data that is available for reporting n Not optimized for query performance ã SAP AG 2004, Business Information Warehouse / 17
Info. Providers are the objects or views relevant to reporting. All BW objects for which queries in SAP BW can be created or executed are Info. Providers. Examples for Info. Providers are: Info. Cubes ODS Objects Multi. Providers Info. Objects ã SAP AG 2004, Business Information Warehouse / 18
Multi. Provider = Union of Info. Providers homogeneous Multi. Provider n same Characteristics and Key Figures in all participating Info. Providers ("partprov") n example: Multi. Provider with identical Info. Cubes Info. Cube 1: data for EUROPE u Info. Cube 2: data for ASIA u Info. Cube 3: data for AMERICAS u n purpose: partitioning on Info. Provider level heterogeneous Multi. Provider n only a subset of common Characteristics n purposes: integrating scenarios that share some semantics u combine differing aggregation levels (e. g. plan – actual scenarios) u tackle sparse tables u ã SAP AG 2004, Business Information Warehouse / 19
Multi. Provider Example Multi. Provider Basic Cube ã SAP AG 2004, Business Information Warehouse / 20 Basic Cube
Queries A query is a collection of characteristics and key figures (Info. Objects) for the analysis of the data of an Info. Provider. A query always refers exactly to one Info. Provider, whereas you can define as many queries as you like for each Info. Provider. ã SAP AG 2004, Business Information Warehouse / 21
Content n Introduction n Reporting n Business content n Data loading n Info. Cube Design n Aggregates n BW-BPS Business Planning & Simulation n Monitoring & Technical Risks ã SAP AG 2004, Business Information Warehouse / 22
Business Information Warehouse: Architecture Business Explorer Web Reporting 3 rd Party Tools client BAPI Administrator Workbench OLAP processor Meta Data Repository Persistent Staging Engine BAPI Data Sources ã SAP AG 2004, Business Information Warehouse / 23 Info. Cubes ODS Info. Object Business Information Warehouse Server
Query Design BEx Query Designer q Ease-of use via drag & drop q Personalized access q Comfortable formula editor for calculations q One-step web publishing q Windows-based component q Web interface for intuitive adhoc analysis on the web Only Filter and Column Section in tabular mode ã SAP AG 2004, Business Information Warehouse / 24
Business Explorer Analyzer Windows Start menu → Programs → Business Explorer → Analyzer You may choose a single query or a workbook, which executes several queries at once. ã SAP AG 2004, Business Information Warehouse / 25
Web Reporting Queries can be published to the Web using the BEx, accessible then via URL If the standard web template does not fit customer may use the BEx Web Application Designer to change the template ã SAP AG 2004, Business Information Warehouse / 26
Reporting - Integration with Crystal Reports and documents optimized for printing and → Sharing here we go, that’s the main reason for using crystal Out of the box presentation-quality reporting Broad range of pre-defined crystal reports: legal, financial, etc SAP and non-SAP data in a single report Seamless portal integration Schedule and view Crystal reports in managed web environment Offline reporting and viewing of reports ã SAP AG 2004, Business Information Warehouse / 27
BI Suite: Business Explorer (BEx) 3. 5 Portal Integration ã SAP AG 2004, Business Information Warehouse / 28
Key Functions: Information Broadcasting allows the distribution of BI information. . . via different channels. . . ( ) E-Mail (works independently from an EP installation) ( ) Enterprise Portal . . . in different formats. . . ( ) HTML, MHTML ( ) BEx Analyzer Workbooks ( ) ZIP Files … of different sources … ( ) BI Web Applications - Dashboards, cockpits ( ) BEx Analyzer Workbooks ( ) Queries … in different modes… ( ) Online & pre-calculated ã SAP AG 2004, Business Information Warehouse / 29
Key Functions: Information Broadcasting supports different business scenarios ( ) Event based (“Intelligent push”) n Integration into process chains u E. g If new data is loaded into the data container (Info. Cube) ( ) Ad hoc n BEx Broadcasting Wizard for one-step distribution ( ) Scheduled n BEx Broadcaster u Guided scheduling times (for end users / information consumers) u. Ensures system performance because of better load balancing u Scheduling at any time (for power users / administrators) u. Create scheduling slots for specific user groups u. No time restriction and no target restriction u. Create pre-calculations based on the data authorizations of the target user ã SAP AG 2004, Business Information Warehouse / 30
Скачать презентацию BW and BW Reporting Introduduction UNWBW 1
1a037f011b53bd0d54eb68f8f1bf6bac.ppt