SAP BI/BW Interview Questions and Answers

Q1. Explain the architecture of SAP BW system and its components

Ans: OLAP Processor
Metadata Repository,
Process designer and other functions.
Business Explorer BEx is reporting and analysis tool that support query, analysis and reporting functions in BI. Using BEx, you can analyze historical and current data to different degree of analysis.

Q2. What is an InfoObject and why it is used in SAP BI?

Ans: Info Objects are known as 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.

Q3. What are the different categories of InfoObjects in BW system?

Ans: Info Objects can be categorized into below categories −

• Characteristics like Customer, Product, etc.
• Units like Quantity sold, currency, etc.
• Key Figures like Total Revenue, Profit, etc.
• Time characteristics like Year, quarter, etc.

Q4. What is the use of Infoarea in SAP BW system?

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

Q5. How do you access to source system data in BI without extraction?

Ans: To access data in BI source system directly. You can directly access to source system data in BI without extraction using Virtual Providers. Virtual providers can be defined as InfoProviders where transactional data is not stored in the object. Virtual providers allow only read access on BI data.

Q6. What are different types on Virtual providers?
Ans: VirtualProviders based on DTP
VirtualProviders with function modules
VirtualProviders based on BAPI’s

Q7. Which Virtual Providers are used in which scenario of data extraction?
VirtualProviders based on DTP −

Ans: This type of Virtual Providers are based on the data source or an Info Provider and they take characteristics and key figures of source. Same extractors are used to select data in source system as you use to replicate data into BI system.

Q8. When to Virtual Providers based on DTP?

Ans: When only some amount of data is used.
You need to access up to date data from a SAP source system.
Only few users executes queries simultaneously on the database.

Q9. Virtual Provider with Function Module −

Ans: This Virtual Provider is used to display data from non BI data source to BI without copying the data to BI structure. The data can be local or remote. This is used primarily for SEM application.

Q10. What is the use of Transformation and how the mapping is done in BW?

Ans: Transformation process is used to perform data consolidation, cleansing and data integration. When data is loaded from one BI object to other BI object, transformation is applied on the data. Transformation is used to convert a field of source into the target object format.
Transformation rules −
Transformation rules are used to map source fields and target fields. Different rule types can be used for transformation.

Q11. How do perform real time data acquisition in BW system?

Ans: Real time data acquisition is based on moving data to Business Warehouse in real time. Data is sent to delta queue or PSA table in real time.
Real time data acquisition can be achieved in two scenarios −
By using InfoPackage for real time data acquisition using Service API.
Using Web Service to load data to Persistent Storage Area PSA and then by using real time DTP to move the data to DSO.
Real time Data Acquisition Background Process −
To process data to InfoPackage and data transfer process DTP at regular intervals, you can use a background process known as Daemon.
Daemon process gets all the information from InfoPackage and DTP that which data is to be transferred and which PSA and Data sore objects to be loaded with data.

Q12. What is InfoObject catalog?

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

Q13. What is the use DSO in BW system? What kind of data is stored in DSO’sWhat are the different components in DSO architecture?

Ans: To access data for reporting and analysis immediately after it is loaded,

Q14. What all data sources you have used to acquire data in SAP BW system?

Ans:

• SAP systems (SAP Applications/SAP ECC)
• Relational Database (Oracle, SQL Server, etc.)
• Flat File (Excel, Notepad)
• Multidimensional Source systems (Universe using UDI connector)
• Web Services that transfer data to BI by means of push

Q15. When you are using SAP BI7.x, you can load the data to which component?

Ans: In BW 3.5, you can load data in Persistence Staging Area and also in targets from source system but If you are using SAP BI 7.0 data load should be restricted to PSA only for latest versions.

Q16. What is an InfoPackage?

Ans: An InfoPackage is used to specify how and when to load data to BI system from different data sources. An InfoPackage contains all the information how data is loaded from source system to a data source or PSA. InfoPackage consists of condition for requesting data from a source system.
Note that using an InfoPackage in BW 3.5, you can load data in Persistence Staging Area and also in targets from source system but If you are using SAP BI 7.0 data load should be restricted to PSA only for latest versions.

Q17. What is extended Star schema? Which of the tables are inside and outside cube in an extended star schema?

Ans: In Extended Star schema, Fact tables are connected to Dimension tables and dimension table is connected to SID table and SID table is connected to master data tables. In Extended star schema you have Fact and Dimension tables are inside the cube however SID tables are outside cube. When you load the transactional data into Info cube, Dim Id’s are generated based on SID’s and these Dim id’s are used in fact tables.

Q18. How extended Star schema is different from Star schema?

Ans: In Extended Star schema one fact table can connect to 16 dimensions tables and each dimension table is assigned with 248 maximum SID tables. SID tables are also called Characteristics and each characteristic can have master data tables like ATTR, Text, etc.
In Star Schema, Each Dimension is joined to one single Fact table. Each Dimension is represented by only one dimension and is not further normalized.
Dimension Table contains set of attribute that are used to analyze the data.

Q19. which Data store object is used?

Ans: DataStore object for direct update allows you to access data for reporting and analysis immediately after it is loaded. It is different from standard DSO’s in the way how it processed the data. Data is stored in same format in which it was loaded to DataStore object for direct update by the application.