SAP BEx Tools

1. Fundamentals of BI Reporting

1.1 Basics of Data Warehousing

1.2 Basics of SAP BI Reporting (Tools, InfoProviders, Query Definitions, Reports)

2. Designing Queries with the Query Designer

2.1 Overview of the Query Designer

2.2 The concept of a Query Definition

2.3 Query Designer Layout

2.4 Accessing InfoProviders

2.5 Using the Query Designer Toolbar

2.6 Creating Restricted and Calculated Key Figures

2.7 Advanced Calculations with Data functions

2.8 Using Structures

2.9 Creating fixed Query Outputs

2.10 Using Characteristic Variables

2.11 Creating Exceptions

2.12 Creating Conditions

2.13 Performance Considerations

2.14 Quick fill features

2.15 Sample Scenario

3. Creating High-Impact Workbooks

3.1 Overview of the BEx Analyzer

3.2 The concept of a Workbook

3.3 Using the BEx Analyzer

3.4 Executing a query into the BEx Analyzer

3.5 Using the BEx Analyzer Toolbar

3.6 OLAP Functionality

3.7 Filtering Results

3.8 Integration with Microsoft Excel

3.9 Inserting Additional Queries

3.10 Saving and Distributing Workbooks

3.11 Creating Customized Templates

3.12 Creating Summary Reports with Cell Referencing

3.13 Designing workbooks with the Design Toolbar

3.14 Sample Scenarios

4. Creating Web Applications

4.1 Overview of Web Reporting

4.2 Using the Web Reporting Interface

4.3 OLAP Options

4.4 Adhoc Web-based Query Designer

4.5 Bookmarking Web Reports

4.6 Overview of the Web Application Designer

4.7 Using the Web Application Designer

4.8 Standard Web Items

4.9 Creating Web Templates

4.10 Using Graphs & Charts

4.11 Inserting Multiple Queries

4.12 Publishing Web Templates

4.13 Web reporting URL strings

4.13 Sample Scenarios

5. Report-Report-Interfacing

5.1 Linking Reports

5.2 Prerequisites

5.3 Creating a Jump Target Definition

5.4 Using the Goto function

5.5 Driving Business Analysis

5.6 Practical Examples

6.

Scott, Peter
With 10 years of BW consulting and project management experience, Peter Scott focuses on the reporting capabilities of BW. As an international consultant he has worked on many project deliverables and has logged over 2000 classroom hours teaching BW reporting functionality. He sits on BW "Ask the Expert" panels and is certified in SAP BW.