SAP BW/BI Interview Questions

Are you planning to attend an interview for the SAP BW/BI Developer role but confused on how to crack that interview and also what would be the most probable SAP BW/BI Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked SAP BW/BI Interview Questions which are often asked in multiple interviews.

SAP BW/BI Interview Questions

Q1) Define SAP BW/BI?

Ans: SAP BW/BI is a Business Information Warehouse, also called business intelligence. It allows the user to examine the information from operative SAP applications also from other businesses.

Q2) Define dimension in BW?

Ans: The collection of reference data about a measurable event in data warehousing is known as dimensions in BW.

Q3) How B/W statistics is important?

Ans: It is important because it is useful in measuring the performance of how quickly the queries are calculated or how quickly the data is loaded into BW.

Q4) What is an Info Object and why it is used in SAP BI?

Ans: Info Objects are known as the smallest unit in SAP BI and are used in Info Providers, DSO’s, Multi providers, etc. Each Info Provider contains multiple Info Objects. InfoObjects are used in reports to analyze the data stored and to provide information to decision-makers.

Q5) What is the use of the Info area in the SAP BW system?

Ans: Info areas in SAP BI are used to group similar types of objects together. Info areas are used to manage Info Cubes and Info Objects. Each Info Objects resides in an Info Area and you can define it as a folder that is used to hold similar files together.

Q6) What is the Info Object catalog?

Ans: InfoObjects are created in the Info Object catalog. It is possible that an Info Object can be assigned to different Info Catalog.

Q7) When you define aggregates, what are the available options?

Ans: Hierarchy F fixed value Blank

Q8) Explain the difference between Operation Datastore, InfoCube and MultiProvider?

Ans: ODS −They provide granular data, allows overwrite and data is in transparent tables, ideal for drill-down and RRI. InfoCube −This is used for star schema, we can only append data, ideal for primary reporting. MultiProvider −It contains physical data and allow to access data from different InfoProviders.

Q9) Explain the data target administration task.

Ans: The data-target administration task deletes the index, generates an index, constructs database statistics, initial fill of new aggregates, etc.

Q10) What are the options available in the transfer rule?

Ans: ABAP routine or a Formula Assign a Constant Assign info object

Q11) What all options are available in the transfer rule?

Ans: Formula Routine Constant InfoObject

Q12) How we can debug errors with SAP GUI?

Ans: To debug errors in SAP GUI we have to follow the path

1. Run Bexanalyzer
2. Business Explorer menu item
3. Installation check

It will show an excel sheet with a start button, on clicking on it, it will verify the GUI installation

Q13) Define the term ‘slowly changing dimension.

Ans: Slowly changing dimensions is the dimension that changes with time