Table of Contents (Download
TOC here)
FOREWORD
........................................................................
10
INTRODUCTION
................................................................... 11
KEY QUESTIONS
................................................................. 13
Basic............................................................................................
14
Intermediate
.................................................................................
16
Expert
..........................................................................................
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
.....................................................................................
95
Query properties
..........................................................................
100
Document utility
..........................................................................
103
Query Administration
.................................................................... 104
Conditions and Exceptions
............................................................ 105
Reporting Agent
...........................................................................
108
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
Business Content and roles
............................................................ 151