Basic............................................................................................ 14

Intermediate ................................................................................. 16

Senior Professional ........................................................................ 21

CHAPTER 1: BW Administration and Design ......................25

Basic Concepts ............................................................................. 26

BW Settings in SPRO ..................................................................... 44

Non Cumulative Key Figures ............................................................ 47

Authorizations .............................................................................. 50

BW Archival and retrieve ................................................................ 55

Process Chains .............................................................................. 57

Open Hub ..................................................................................... 62

Tuning ......................................................................................... 64

RSRV ............................................................................................ 67

ODS............................................................................................ 69

BW Statistics ................................................................................ 72

Aggregates ....................................................................................74

CHAPTER 2: BW Reporting (BeX and Web Reporting)........ 79

Business Explorer ......................................................................... 80

Calculated key figures ................................................................... 82

Boolean Operators ........................................................................ 84

Structures and cells ...................................................................... 85

Before and after aggregation .......................................................... 86

Key figure properties ..................................................................... 88

Hierarchies in Reports ................................................................... 90

User Exits for Bex Reporting ........................................................... 92

Variables, Variables, Variables, Variables .......................................... 95

Query properties .......................................................................... 100

Document utility .......................................................................... 103

Query Administration .................................................................... 105

Conditions and Exceptions ............................................................ 106

Reporting agents ......................................................................... 109

WAD Web Application Designer ........................................................ 112

CHAPTER 3: Extraction .................................................... 121

Basic Concepts ............................................................................ 122

Class System .............................................................................. 129

Generic Data source ..................................................................... 130

LIS Extraction............................................................................... 131

LO Extraction .............................................................................. 134

CO-PA Extraction ..........................................................................137

CO-PA Retraction ......................................................................... 140

Enhancing data extraction ............................................................. 142

DB Connect ................................................................................. 145

Currency Translation in BW ........................................................... 147

CHAPTER 4: BW Functional ............................................. 149

ASAP methodology ....................................................................... 150