BW and BW Reporting Introduduction

1. BW and BW ReportingIntroduduction UNWBW1 – Business Information Warehouse NetWeaver Support Consultant Training

2. Content • Introduction • Reporting • Business content • Data loading • InfoCube Design • Aggregates • BW-BPS Business Planning & Simulation • Monitoring & Technical Risks

3. SAP Mobile Infrastructure Tight coupling and alignmentwith SAP business solutions SAP Enterprise Portal Business packages Collaboration SAP Business Information Warehouse Business content Open architecture (Crystal, Ascential) Master Data Management SAP Exchange Infrastructure Cross-component business processes Shared integration knowledge SAP Web Application Server Proven, scalable, comprehensive toolsets Leverage existing infrastructure/skillsets Multi-Channel Access Portal Collaboration BusinessIntelligence KnowledgeManagement Master Data Management Business ProcessManagement Integration Broker J2EE ABAP DB and OS Abstraction SAP NetWeaver in Detail SAP NetWeaver™ People Integration Composite Application Framework Life Cycle Management Multi-Channel Access Portal Collaboration Information Integration BusinessIntelligence KnowledgeManagement Master Data Management Process Integration Business ProcessManagement Integration Broker Application Platform J2EE ABAP DB and OS Abstraction DB and OS Abstraction

4. Information-Based Management How do we get from here . . . to here? Knowledge Data Results Information Realizing business value from transaction data

5. Data Warehouse Definitions • 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 • A copy of transaction data specifically structured for query and analysis.R. Kimball, “The Data Warehouse Toolkit,” 1996, page 310

6. Data Warehouse Objectives • Standardized structures and representation for all enterprise information • Easy-to-use access, single-point of access to all enterprise information • Self-service, high quality business reporting and analysis on all levels • Fast and cost-effective to deploy • High performance environment fed from heterogeneous sources • Freed-up systems and IT resources in OLTP environment

7. SAP Business Information Warehouse • Data Warehouse system with optimized structures for reporting and analysis • OLAP engine and tools • Integrated meta data repository • Data extraction and data staging • Preconfigured support for data sources from R/3 Systems • BAPIs for data sources from non-SAP systems • Automated Data Warehouse management • Administrator Workbench for controlling and managing content • Only one productive client

8. InfoCubes ODS client BAPI BAPI Business Information Warehouse: Architecture Business Explorer Web Reporting 3rd Party Tools BusinessInformation WarehouseServer OLAP processor Administrator Workbench Meta DataRepository Staging Engine InfoObject Data Sources

9. Characteristics OLTP OLAP Primary Operation Update 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 (100s to 1000s) Few Response time Quick Reasonable Database data Normalized Denormalized Type of processing Well defined Ad hoc OLTP versus OLAP

10. Administrator Workbench (RSA1) 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

11. CO Controlling HR Human Resources R/3 OLTP What is an InfoObject ? The various OLTP data models are unified for BWBusiness objects / table fields become InfoObjects Table of cost centers InfoObject “0COSTCENTER” Table of employees InfoObjects are unique across application components !

12. Types of InfoObjects • Characteristics: evaluation groups like “Cost Center”, “Product group”, “Material” • Have discrete values stored in their master data tables(e.g. the characteristic “Region” has the values “North”, “South”, ... ) • Special types of characteristics: • Time characteristics like “Fiscal period”, “Calendar year” • Unit characteristics which comprise currencies and units of measure like “Local currency” • Key figures: continuously valued numerical fields like amounts and quantities (e.g.: “Revenue” and “Sales quantity”)

13. Master Data tables for Characteristics • Information about characteristics is stored in • Master Data Tables: • Attribute Tables • Dependent attributes of a characteristic can be stored in an Attribute Table for the characteristic. • Text Tables • Textual descriptions of a characteristic are stored in a separate text table. • External Hierarchy Tables • Hierarchies of characteristics or attributes may be stored in separate hierarchy tables. Material Attribute Table MATERIAL_ID Material GroupMaterial Type Material Text Table MATERIAL_ID Material Name Material Hierarchy

14. InfoCube • Central data store for reports and evaluations • Contains two types of data • Key figures • Characteristics • 2 fact tables and 16 dimension tables • 3 Dimensions are predefined by SAP • Time • Unit • Packet

15. InfoCube: Example Customer group Region North South East Dept. Stores Wholesale Retail Glass- Ceramics Plastics Pottery Copper Pewter ware Division

16. 1 2 3 InfoCube: Multi-dimensional analysis Characteristics: InfoCube Product group Customer group Division Area Company code Region Period Profit Center Bus. Area East Customer group Region South DeptStores Wholesale North Retail Glass- ware Ceramics Plastics Division Analysisof Ceramics division Analysisof Plastics division Analysis of Plastics division and Southern region East East East Customer group Customer group Customer group Region Region Region South South South DeptStores DeptStores DeptStores Wholesale Wholesale Wholesale North North North Retail Retail Retail Glass- ware Ceramics Plastics Glass- ware Ceramics Plastics Glass- ware Ceramics Plastics Division Division Division

17. Operational Data Store • The BW ODS-Object: • Stores transaction data • Is a denormalized data structure • Transparent table • Not a star schema • Can hold data that is available for reporting • Not optimized for query performance

18. InfoProvider • InfoProviders are the objects or views relevant to reporting. All BW objects for which queries in SAP BW can be created or executed are InfoProviders. • Examples for InfoProviders are: • InfoCubes • ODS Objects • MultiProviders • InfoObjects

19. MultiProvider • MultiProvider = Union of InfoProviders • homogeneous MultiProvider • same Characteristics and Key Figures in all participating InfoProviders ("partprov") • example: MultiProvider with identical InfoCubes • InfoCube 1: data for EUROPE • InfoCube 2: data for ASIA • InfoCube 3: data for AMERICAS • purpose: partitioning on InfoProvider level • heterogeneous MultiProvider • only a subset of common Characteristics • purposes: • integrating scenarios that share some semantics • combine differing aggregation levels (e.g. plan – actual scenarios) • tackle sparse tables

20. MultiProvider Example MultiProvider Basic Cube Basic Cube

21. Queries A query is a collection of characteristics and key figures (InfoObjects) for the analysis of the data of an InfoProvider. A query always refers exactly to one InfoProvider, whereas you can define as many queries as you like for each InfoProvider.

22. Content • Introduction • Reporting • Business content • Data loading • InfoCube Design • Aggregates • BW-BPS Business Planning & Simulation • Monitoring & Technical Risks

23. InfoCubes ODS client BAPI BAPI Business Information Warehouse: Architecture Business Explorer Web Reporting 3rd Party Tools BusinessInformation WarehouseServer OLAP processor Administrator Workbench Meta DataRepository Persistent Staging Engine InfoObject Data Sources

24. Query Design • BEx Query Designer • Ease-of use via drag & drop • Personalized access • Comfortable formula editor for calculations • One-step web publishing • Windows-based component • Web interface for intuitive ad-hoc analysis on the web Only Filter and Column Section in tabular mode

25. 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.

26. Web Reporting Queries can be published to the Web using the BEx, accessible then via URL If the standard webtemplate does not fitcustomer may use theBEx Web Application Designer to change the template

27. Reporting - Integration with Crystal Reports • 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 singlereport • Seamless portal integration • Schedule and view Crystal reports in managed web environment • Offline reporting and viewing of reports

28. BI Suite: Business Explorer (BEx) 3.5 Portal Integration

29. Key Functions: Information Broadcasting • 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

30. Key Functions: Information Broadcasting Information Broadcasting supports different business scenarios () Event based (“Intelligent push”) • Integration into process chains • E.g If new data is loaded into the data container (InfoCube) () Ad hoc • BEx Broadcasting Wizard for one-step distribution () Scheduled • BEx Broadcaster • Guided scheduling times (for end users / information consumers) • Ensures system performance because of better load balancing • Scheduling at any time (for power users / administrators) • Create scheduling slots for specific user groups • No time restriction and no target restriction • Create pre-calculations based on the data authorizations of the target user