SAP BW Interview Preparation Guide
Strengthen your SAP BW interview skills with our collection of 3 important questions. These questions will test your expertise and readiness for any SAP BW interview scenario. Ideal for candidates of all levels, this collection is a must-have for your study plan. Download the free PDF now to get all 3 questions and ensure youre well-prepared for your SAP BW interview. This resource is perfect for in-depth preparation and boosting your confidence.3 SAP BW Questions and Answers:
1 :: SAP Business Warehouse interview questions part 1:
Explain:
a.) ODS
b.) Table partition
c.) MultiProvider
d.) Web template
e.) Dash board
What is an infocube? What are its different types?
How much time would it take to extract 1 million data from infocube?
How much time would it take to upload 1 million data to infocube?
How would you measure the size of a infocube?
How would you do the following?
a.) Unloading non-cumulative cubes.
b.) Archiving cubex.
c.) Optimizing the dimensions
d.) Calling a BW query from an ABAP program.
List the steps to do the following:
a.) Converting from LIS to LO extraction.
b.) Creating classes in SAP-BW
c.) Extractig data from R/3.
d.) Configuring third party (BAPI) tools.
a.) ODS
b.) Table partition
c.) MultiProvider
d.) Web template
e.) Dash board
What is an infocube? What are its different types?
How much time would it take to extract 1 million data from infocube?
How much time would it take to upload 1 million data to infocube?
How would you measure the size of a infocube?
How would you do the following?
a.) Unloading non-cumulative cubes.
b.) Archiving cubex.
c.) Optimizing the dimensions
d.) Calling a BW query from an ABAP program.
List the steps to do the following:
a.) Converting from LIS to LO extraction.
b.) Creating classes in SAP-BW
c.) Extractig data from R/3.
d.) Configuring third party (BAPI) tools.
2 :: SAP Business Warehouse interview questions part 2:
List the tools to monitor overall query performance.
What do you mean by following?
a.) Start routines
b.) Transfer routines
c.) Update routines
Explain return tables. How do start routine and return table synchronize with each other?
Situation -
a.) You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?
b.) You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?
List the steps to configure SD and MM for BW.
You want to see the log of transport connection. What t-code would you use? List the steps.
List the steps you would take to create your dashboard in BW.
What do you mean by following?
a.) Start routines
b.) Transfer routines
c.) Update routines
Explain return tables. How do start routine and return table synchronize with each other?
Situation -
a.) You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?
b.) You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?
List the steps to configure SD and MM for BW.
You want to see the log of transport connection. What t-code would you use? List the steps.
List the steps you would take to create your dashboard in BW.
3 :: SAP Business Warehouse interview questions part 3:
You want to see the error idocs. Tell the navigation you would use.
You want to see if the execution of a query has been slow or fast. How would you do that?
Differentiate between v1, v2, v3 jobs in extraction.
Explain Business Blueprint Stage. What do you do here?
You want to convert BeX query Global structure to Local structure. How would you do that?
You want to start an implementation project. List the steps you would take to gather the requirements.
Explain:
a.) Customization
b.) Tickets
c.) BP Master data
d.)0Record Mode
You want to see if the execution of a query has been slow or fast. How would you do that?
Differentiate between v1, v2, v3 jobs in extraction.
Explain Business Blueprint Stage. What do you do here?
You want to convert BeX query Global structure to Local structure. How would you do that?
You want to start an implementation project. List the steps you would take to gather the requirements.
Explain:
a.) Customization
b.) Tickets
c.) BP Master data
d.)0Record Mode