SAP BI/BW Frequently Asked Interview Questions
Q1. What is SAP BW/BI? What is the cause of SAP BW/BI?
Ans: SAP BW/BI stands for Business Information Warehouse, also called business intelligence. For any business, facts reporting, analyses and interpretation of commercial enterprise information could be very crucial for walking business easily and making selection. SAP BW/BI manage the information and permits to react quickly and in line with the market. It permits the user to analyze statistics from operative SAP applications as well as from different enterprise.
Q2. What are the primary regions and sports in SAP/BI?
a) Data Warehouse: Integrating, collecting and coping with whole organization’s facts.
B) Analyzing and Planning: Using the facts stored in facts warehouse.
C) Broad solid publishing: To send the information to the personnel the use of e-mail, fax etc.
D) Reporting: BI offers the equipment for reporting in net-browser, excel etc
Q3. What all statistics sources you have used to collect facts in SAP BW gadget?
SAP systems (SAP Applications/SAP ECC)
Relational Database (Oracle, SQL Server, and many others.)
Flat File (Excel, Notepad)
Multidimensional Source systems (Universe the usage of UDI connector)
Web Services that switch information to BI with the aid of push
Q4. What is an InfoPackage?
Ans: An InfoPackage is used to specify how and whilst to load data to BI device from different facts assets. An InfoPackage carries all the data how statistics is loaded from source machine to a statistics source or PSA. InfoPackage includes situation for asking for statistics from a supply gadget.
Note that the use of an InfoPackage in BW 3.5, you can load information in Persistence Staging Area and additionally in objectives from source device however If you are the usage of SAP BI 7.Zero data load ought to be constrained to PSA most effective for modern versions.
Q5. What is desk partition?
Ans: Table partition is finished to control the huge facts to enhance the efficiency of the applications. The partition is primarily based on 0CALMONTH and 0FISCPER. There are type of partitioning that is finished
Q6. What are the functions of multi issuer?
a) It doesn’t contain any type of information.
B) The statistics comes completely from the records that is provided.
C) By union operations the information carriers are linked.
Data flows from a transactional machine to the analytical device (BW). DS ( Data Service) on the transactional gadget wishes to be replicated on BW side and connected to info supply and update guidelines respectively.
Q7. What is ODS (Operational Data Store)?
Ans: 'Operational Data Store' or 'ODS' is used for detailed storage of records. It is a BW architectural thing that appears among PSA ( Persistent Staging Area) and infocubes, it permits BEX (Business Explorer) reporting. It is in the main used for element reporting instead of dimensional analysis, and it isn't always based on the big name schema. ODS (Operational Data Store) items do no longer combination statistics as infocubes do. To load the statistics into an IDS object, new statistics are inserted, existing records are up to date, or vintage data are deleted as certain by way of RECORDMODE fee.
Q8. 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 utilized in Info Providers, DSO’s, Multi carriers, and so on. Each Info Provider carries multiple Info Objects.
InfoObjects are used in reports to research the records stored and to offer facts to choice makers.
Q9. How do you get entry to to supply device records in BI without extraction?
Ans: To get entry to facts in BI supply system at once. You can at once access to supply device statistics in BI without extraction the use of Virtual Providers. Virtual providers may be defined as InfoProviders wherein transactional statistics is not saved inside the object. Virtual vendors permit only read get admission to on BI facts.
Q10. What is using Transformation and the way the mapping is achieved in BW?
Ans: Transformation technique is used to carry out data consolidation, cleaning and records integration. When statistics is loaded from one BI object to different BI item, transformation is applied on the records. Transformation is used to convert a area of source into the target item layout.
Transformation regulations −
Transformation regulations are used to map source fields and goal fields. Different rule types may be used for transformation.
Q11. What is UD connect in SAP BW gadget? How does it allow reporting in BI device?
Ans:Universal facts UD join permits you to get right of entry to Relational and multidimensional statistics sources and switch the information in form of flat information. Multidimensional records is converted to flat format when Universal Data Connect is used for information transfer.
UD makes use of J2EE connector to permit reporting on SAP and non-SAP facts. Different BI Java connectors are available for diverse drivers, protocols as useful resource adapters −
BI ODBO Connector
BI JDBC Connector
BI SAP Query Connector
Q12. What is the difference among ODS and Info-cubes?
Ans: The difference between ODS and Info-cubes are
ODS has a key while Info-cubes does no longer have any key
ODS consists of detailed level statistics at the same time as Info-dice consists of delicate facts
Info-cube follows Star Schema (16 dimensions) while ODS is a flat report shape
There can be two or more ODS below a dice, so cube can comprise blended information or data that is derived from different fields in the ODS
Q13. How many data types are there in traits information object?
Ans: There are four data sorts:
Q14. What are the T-codes for Info-cubes?
Ans: The T-codes for Info-Cubes are
a) LISTSCHEMA: Show InfoCube schema
b) LISTCUBE: List viewer for InfoCubes
c) RSDCUBE, RSDCUBED, RSDCUBEM: Start InfoCube modifying
Q15. Write the styles of Multi-carriers?
Ans: The kinds of Multi-providers are:
a) Heterogeneous Multi providers: These data-vendors handiest have a few number of characteristics and key figures. It may be used for the modelling of situations by way of dividing them into sub-eventualities. Each sub-scenario is represented through its personal information-issuer.
B) Homogeneous Multi providers: It consists of technically identical data-providers, inclusive of infocubes with exactly the same traits and key figures.
Q16. What do you recognize via information goal management assignment?
Ans: Data goal management assignment includes
a) Complete deletion of statistics goal
b) Construct database statistics
c) Generate Index
d) Delete Index
Q17. What is B/W facts and the way it's far used?
Ans: The sets of cubes introduced through SAP are used to measure performance for question, loading statistics etc. B/W facts because the call indicates is useful in displaying information approximately the costs related to the B/W queries, OLAP, aggregative data etc. It is beneficial to degree the overall performance of ways quick the queries are calculated or how fast the information is loaded into BW.