SAP Business Warehouse Interview Preparation Guide
Prepare comprehensively for your SAP Business Warehouse interview with our extensive list of 17 questions. Each question is crafted to challenge your understanding and proficiency in SAP Business Warehouse. Suitable for all skill levels, these questions are essential for effective preparation. Download the free PDF to have all 17 questions at your fingertips. This resource is designed to boost your confidence and ensure youre interview-ready.17 SAP Business Warehouse Questions and Answers:
1 :: What is Open Hub (OH)?
THIS IS USED TO SEND THE DATA TO DIFFERENT EXTERNAL SYSTEMS.
THIS IS PROCESS OF SENDING CONSOLIDATED AND CLENASED DATA
TO DIFFERENT EXTERNAL SYSTEMS LIKE.
TRANSPARENT FILE, DATABASE, ODBO, FLAT FILE
TRANSACTION USED FOR IT IS : RSBO
THIS IS PROCESS OF SENDING CONSOLIDATED AND CLENASED DATA
TO DIFFERENT EXTERNAL SYSTEMS LIKE.
TRANSPARENT FILE, DATABASE, ODBO, FLAT FILE
TRANSACTION USED FOR IT IS : RSBO
2 :: What is the transfer routine of the info object?
transfer routines are used to define global data and global
checks
checks
3 :: Define the record modes for delta?
After image " "
Before image "x"
Delete image "D"
reverse image "R"
New image "N"
Additive image "A"
Before image "x"
Delete image "D"
reverse image "R"
New image "N"
Additive image "A"
4 :: What are text variables?
Text variables represent a text and can be used in
descriptions of queries, calculated key figures and
structural components.
descriptions of queries, calculated key figures and
structural components.
5 :: What is virtual info cube with services?
Remote InfoCubes with services refer to data stored on a
remote system available through a user-defined function
module. This type of remote InfoCube allows flexible user-
defined online access to data stored on an arbitrary remote
system.
remote system available through a user-defined function
module. This type of remote InfoCube allows flexible user-
defined online access to data stored on an arbitrary remote
system.
6 :: Is it possible to cancel the "collapse" process in Process chain. if yes. Briefly explain how to cancel the process?
We can collapse the process in process chain manually.
7 :: What is differences between QUEUE DELTA & DIRECT DELTA?
In case of queued delta LUW's r posted to extractor queue
by scheduling V3job we move the documents from Extactor
queue to Delta queue and we extract LUW's from Deltaqueue
to SAP BW by running Delta loadsQueued delta maintains
Extractor log to handle the LUW's which r missed.
In case of Direct delta LUW's r directly posted to Delta
Queue(RSA7)and we extact the LUW's from DeltaQueue to SAP
BW by running Delta loads.It degrades the OLTP performance
becoz when LUW's r directly posted to DeltaQueue the
application is kept waiting until all the enhancement code
is executed.
by scheduling V3job we move the documents from Extactor
queue to Delta queue and we extract LUW's from Deltaqueue
to SAP BW by running Delta loadsQueued delta maintains
Extractor log to handle the LUW's which r missed.
In case of Direct delta LUW's r directly posted to Delta
Queue(RSA7)and we extact the LUW's from DeltaQueue to SAP
BW by running Delta loads.It degrades the OLTP performance
becoz when LUW's r directly posted to DeltaQueue the
application is kept waiting until all the enhancement code
is executed.
8 :: What is the RRI. What is the sructure of RRI. any conditions for RRI?
The report/report interface (RRI) makes the parameterized
call of programs possible from other programs. It gives the
user the ability to jump from one report into another
report that supplies further information. In SAP BI, you
can arrive at branch destinations within and outside of the
BI system.
With the report/report interface, you can create several
individual reports, each with a limited number of
characteristics. These can be linked one to another to
make very flexible data evaluations possible online.
call of programs possible from other programs. It gives the
user the ability to jump from one report into another
report that supplies further information. In SAP BI, you
can arrive at branch destinations within and outside of the
BI system.
With the report/report interface, you can create several
individual reports, each with a limited number of
characteristics. These can be linked one to another to
make very flexible data evaluations possible online.
9 :: How to stop the Collapse process in process chain?
Go to the batch monitor in the Collapse process of the
process chain. go to job log, select the job and stop it.
It will cancell that process.
Note: You have to do it after the execution & before finish
of the job.
process chain. go to job log, select the job and stop it.
It will cancell that process.
Note: You have to do it after the execution & before finish
of the job.
10 :: What is dsp. How many types of dsos?
A DataStore object is used to store consolidated and
cleansed data (transaction data or master data) on a
document level (atomic level).
SAP BI distinguishes between three DataStore object types:
Standard, Write Optimized, and Direct Update.
cleansed data (transaction data or master data) on a
document level (atomic level).
SAP BI distinguishes between three DataStore object types:
Standard, Write Optimized, and Direct Update.