sap bw bi latest interview questions with answers by garuda trainings

www.garudatrainings.com

SAP BW BI Interview Questions

1. What is data integrity?

www.garudatrainings.com

Data Integrity is about eliminating duplicate entries in the database. Data

integrity means no duplicate data.

2. What is the difference between SAP BW 3.0B and SAP BW 3.1C, 3.5?

www.garudatrainings.com

The best answer here is Business Content. There is additional Business Content

provided with BW 3.1C that wasn’t found in BW 3.0B. SAP has a pretty decent

reference library on their Web site that documents that additional objects found

with 3.1C.

3. What is index?

www.garudatrainings.com

Indices/Indexes are used to locate needed records in a database table quickly. BW

uses two types of indices, B-tree indices for regular database tables and bitmap

indices for fact tables and aggregate tables.

4. What is KPIs (Key Performance Indicators)?

www.garudatrainings.com

1) Predefined calculations that render summarized and/or aggregated

information, which is useful in making strategic decisions.

(2) Also known as Performance Measure, Performance Metric measures. KPIs

are put in place and visible to an organization to indicate the level of progress

and status of change efforts in an organization.

KPIs are industry-recognized measurements on which to base critical business

decisions.

In SAP BW, Business Content KPIs have been developed based upon input

from customers, partners, and industry experts to ensure that they reflect best

practices.

5. What is the use of process chain?

www.garudatrainings.com

The use of Process Chain is to automate the data load process.

Used to automate all the processes including Data load and all Administrative

Tasks like indices creation deletion, Cube compression etc.

Highly controlled data loading.

6. Difference between Display Attribute and Navigational Attribute?

www.garudatrainings.com

The basic difference between the two is that navigational attributes can be used

to drilldown in a Bex report whereas display attributes cannot be used so. A

navigational attribute would function more or less like a characteristic within a

cube.

To enable these features of a navigational attribute, the attribute needs to be

made navigational in the cube apart from the master data info-object.

The only difference is that navigation attributes can be used for navigation in

queries, like filtering, drill-down etc.

7. If there are duplicate data in Cubes, how would you fix it?

www.garudatrainings.com

Delete the request ID, Fix data in PSA or ODS and re-load again from PSA / ODS.

8. What are the differences between ODS and Info Cube?

www.garudatrainings.com

ODS holds transactional level data. It’s just as a flat table. It’s not based on

multidimensional model. ODS have three tables

1.Active Data table (A table containing the active data)

2.Change log Table (Contains the change history for delta updating from the

ODS Object into other data targets, such as ODS Objects or Info Cubes for

example.)

3.Activation Queue table (For saving ODS data records that are to be

updated but that have not yet been activated. The data is deleted after the

records have been activated)

9. What is the use of change log table?

www.garudatrainings.com

Change log is used for delta updates to the target; it stores all changes per request

and updates the target.

10. What is the T.Code for Data Archival and what is it’s advantage?

www.garudatrainings.com

SARA.

Advantage: To minimize space, Query performance and Load performance

11. What is OSS?

www.garudatrainings.com

OSS is Online support system runs by SAP to support the customers.

You can access this by entering OSS1 transaction or visit

Service.SAP.Com and access it by providing the user name and password.

12. How to unlock objects in Transport Organizer?

www.garudatrainings.com

To unlock a transport use Go to SE03 –> Request Task –> Unlock Objects

Enter your request and select unlock and execute. This will unlock the request.

13. What is InfoPackage Group?

www.garudatrainings.com

An InfoPackage group is a collection of InfoPackages.

14. What are the critical issues you faced and how did you solve it?

www.garudatrainings.com

Find your own answer based on your experience.

15. What is Conversion Routine?

www.garudatrainings.com

a) Conversion Routines are used to convert data types from internal format to

external/display format or vice versa.

b) These are function modules.

c) There are many function modules, they will be of type

CONVERSION_EXIT_XXXX_INPUT,

CONVERSION_EXIT_XXXX_OUTPUT.

example:

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

16. Difference between Start Routine and Conversion Routine?

www.garudatrainings.com

In the start routine you can modify data packages when data loading. Conversion

routine usually refers to routines bound to InfoObjects (or data elements) for

conversion of internal and display format.

17. What is the use of setup tables in LO extraction?

www.garudatrainings.com

The use of setup table is to store your historical data in them before updating to the

target system. Once you fill up the setup tables with the data, you need not to go to

the application tables again and again which in turn will increase your system

performance.

18. R/3 to ODS delta update is good but ODS to Cube delta is broken. How to fix it?

www.garudatrainings.com

i. Check the Monitor (RSMO) what’s the error explanation. Based on

explanation, we can check the reason

ii. Check the timings of delta load from R3 – ODS – CUBE if conflicting after

ODS load

iii. Check the mapping of Transfer/Update Rules

iv. Fails in RFC connection

v. BW is not set as source system

vi. Dump (for a lot of reasons, full table space, time out, sql errors…)

Do not receive an IDOC correctly.

vii. There is a error load before the last one and so on…

Contact us For More Stuff:

www.garudatrainings.com

www.garudatrainings.com Mail : garudatrainings@gmail.com,

contact@garudatrainings.com

Phone : +1(508)841-6144