SAP Business Warehouse Interview Preparation Guide
Download PDF

SAP Business Warehouse frequently Asked Questions in various SAP Business Warehouse job Interviews by interviewer. Get preparation of SAP Business Warehouse job interview

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

2 :: What is the transfer routine of the info object?

transfer routines are used to define global data and global
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"

4 :: What are text variables?

Text variables represent a text and can be used in
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.

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.

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.

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.

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.