201
Interview
Questions
TABLE OF CONTENTS
FOREWORD
........................................................................
10
KEY QUESTIONS
.................................................................
13
Basic
............................................................................................
14
Intermediate
.................................................................................
16
Expert
.........................................................................................
2l
......................
CHAPTER
1:
BW Administratio11 and Design
25
Basic Concepts
.............................................................................
26
BW Settings in SPRO
.....................................................................
44
Non Cumulative Key Figures
............................................................
47
A~~thorizations
..............................................................................
50
BW
Archival and retrieve
................................................................
55
Process
Chai~is
..............................................................................
57
Open Hub
.....................................................................................
62
Tuning
.........................................................................................
64
RSRV
............................................................................................
67
ODs
............................................................................................
69
BW Statistics
................................................................................
72
Aggregates
...................................................................................
74
Table of contents
........
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 'I03
....................................................................
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
Table of contents
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
Fu~~ctional
.............................................
149
ASAP methodology
.......................................................................
150
............................................................
Business Content and roles
l5l
INTRODUCTION
How to use this book:
As a consultant
/
analyst:
J
Start by reading this book from cover to cover.
J
Repeat that until you think you know all the details.
J
Now practice what you have learnt in the system.
If you are an employer looking to
hirelcontract a BW
professional:
*,
The first part of the book highlights key questions
that you should be able to ask a candidate and
therefore gauge their competency based on their
answers.
J
By randomly adding in a few questions from the rest
of the book you can focus on a specific area and
ensure that the candidate really knows the relevant
information.
J
Before interviewing a candidate, always make sure
that you fully understand the question and the
answer. Although every effort has been made to
make the questions and answers simple in their
explanation, some questions may still not make sense
to an untrained user.
J
We suggest highlighting those questions that you
wish to ask, familiarizing yourself with the answers
and then conducting the interview.