O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SAP Business Information Warehouse Reporting

Book Description

Your Hands-On Guide to SAP Business Information Warehouse

Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance.

  • Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooks
  • Work with the BEx Analyzer, Web Analyzer, and Query Designer
  • Build queries and reports using the Business Administration Workbench
  • Add attachments and drill-through using Document Integration and RRI
  • Format and distribute results using Report Designer and Information Broadcaster
  • Extend functionality with Enterprise Portal, Data Modeling, and Visual Composer
  • Deploy charts, maps, diagrams, and unit of measure conversions
  • Predict trends and possible outcomes using SBC and Integrated Planning
  • Generate HTML pages using Enterprise Reporting and Web Application Designer
  • Create BI-based corporate Web and intranet sites using SAP Enterprise Portal

Table of Contents

  1. Cover 
  2. About the Author
  3. Copyright
  4. Contents at a Glance
  5. Contents 
  6. Acknowledgments
  7. Introduction
  8. 1. SAP Business Intelligence Overview
    1. Challenges of the Current IT Landscapes
    2. SAP NetWeaver: Overview of Components
      1. People Integration: The Use of an Enterprise Portal
      2. Information Integration
      3. Process Integration
      4. Application Platform
      5. SAP Business Warehouse Administration
    3. Summary
  9. 2. Storing the Data—SAP/Business Warehouse InfoProviders
    1. Introduction to SAP BI InfoProviders
      1. Data Targets
      2. Non–Data Targets
  10. 3. Navigating Through the BEx Analyzer
    1. Introduction to the BEx Analyzer
      1. Access to the BEx Analyzer
      2. Navigation Options
    2. Summary
  11. 4. Where It All Starts—The Query Designer
    1. Access the Query Designer
      1. Format of the Query Designer Screen
      2. Toolbars of the Query Designer
      3. Basic Navigation in the BEx Query Designer
      4. Query Properties for the Query Designer
    2. Summary
  12. 5. Configuration in the BEx Query Designer—Working with the Numbers
    1. Introduction to the Key Figures
      1. Restricted Key Figures
      2. Calculated Key Figures
      3. Properties of Key Figures
      4. Structures
      5. Cell Editor
    2. Summary
  13. 6. Enhancing the Use of the Characteristics in the BEx Query Designer.
    1. Characteristics and Navigational Attributes
      1. Characteristic Properties
      2. Hierarchies
      3. Variables in the BEx Query Designer
      4. Personalization in the BEx Query Designer
      5. Exceptions
      6. Conditions
    2. Summary
  14. 7. Double-teaming the Attachments
    1. Report-to-Report Interface
      1. Query-Level RRI and InfoProvider-Level RRI
    2. Document Management
      1. Document Classes
      2. Metadata Level
      3. Master Data Level
      4. InfoProvider Level
      5. Administration of Document Management
    3. Summary
  15. 8. Using the Functionality of the BEx Analyzer
    1. Functions Within the BEx Analyzer—Navigation Within the Design Mode
      1. Design Toolbox Functions
      2. Workbook Settings
      3. Cascading Style Sheets
      4. Reviewing All the Steps
      5. Integrated Excel Functionality, Formulas, and Formatting
    2. Summary
  16. 9. Formatted Reporting—SAP Report Designer
    1. Introduction to the Report Designer
      1. The Final Results of a Report Designer Report
      2. Accessing the Report Designer
      3. Initial Report Designer Functionality
      4. Building a Basic Report in the Report Designer
    2. Summary
  17. 10. Functionality of the Report Designer
    1. Enhanced Functionality of the Report Designer
      1. Use of Hierarchies in the Report Designer
      2. Images
      3. Header and Footer Sections
      4. Field Catalog
      5. Conditional Formatting
      6. Use of Themes in the Report Designer
      7. Using All the Functionality of the Report Designer
    2. Summary
  18. 11. Spreading the Word—The Information Broadcaster
    1. Introduction to the Information Broadcaster
      1. Configuring the System for Information Broadcasting
      2. Accessing the Information Broadcaster
      3. Setup and Functionality of the Information Broadcaster
      4. Output Format
      5. Recipient(s) Tab
      6. Text Tab
      7. General Precalculation Tab
      8. Filter Navigation Tab
      9. Scheduling the Broadcast
      10. Broadcasting Wizard
      11. Workbook Precalculation Service
      12. Example of the Information Broadcaster
    2. Summary
  19. 12. Advanced Configuration of the Information Broadcaster
    1. Advanced Functions of the Information Broadcaster
      1. Precalculated Value Set
      2. Multichannel Distribution
      3. Precalculation of Queries, Query Views, Web Templates, and Reports
      4. Fill OLAP Cache
      5. Bursting Method of Distribution
      6. Printing Process
      7. Exceptions in the Broadcaster
      8. Scheduling of the Information Broadcaster
      9. Management and Monitoring of the Broadcaster
    2. Summary
  20. 13. Advanced Reporting Processes and Functionality
    1. Introduction to Advanced Reporting Processes
      1. Elimination of Internal Business Volume
      2. Unit of Measure Conversion
      3. Web Application Items: Chart and Map
      4. Components of the Query
    2. Summary
  21. 14. Working with SAP BI Standard Business Content
    1. Introduction to BI Standard Business Content for Queries
      1. Standard Functionality for Query Design
      2. Metadata Repository
      3. Standard Business Content
      4. SAP DemoContent
    2. Summary
  22. 15. What the Web Can Do for Your Reporting
    1. Introduction to the BEx Web Analyzer and WAD
      1. Access to the BEx Web Analyzer
      2. Navigation Options in the BEx Web Analyzer
      3. Navigation in a Web Template Query
    2. Introduction to the Web Application Designer (WAD)
      1. Overview of the Web Application Designer
    3. Summary
  23. 16. Organizing Your Reports—Enterprise Portal
    1. Overview of the Enterprise Portal Integration to BW
      1. Navigation with BI Content in the Portal
      2. Access to the Enterprise Portal for Linking BW Objects
      3. Components of the Enterprise Portal
    2. Summary
  24. 17. Other Options with the Analyzer—Integrated Planning (BI-IP) and Visual Composer (VC)
    1. Introduction to the Visual Composer
      1. Components of Visual Composer
      2. Configuration of BI/Visual Composer Integration
    2. Introduction to Integrated Planning
      1. Results of Integrated Planning
      2. Architecture of BW for IP
      3. Planning Modeler
      4. Setting Up the Front Ends for IP
    3. Summary
  25. Index