SAP BW

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.

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.