Top SAP BI/BW Interview Questions And Answers
Wish to Learn SAP BI/BW? Click Here
|Functionality||Data warehousing and reporting tool|
|Comprehensive tool||Seamless integration of back-end, analysis and interpretation|
SAP BW/BI is a Business Information Warehouse, also called as business intelligence. It allows the user to examine information from operative SAP applications also from other business
a) Data Warehouse: Integrating, collecting and managing entire company’s data.
b) Analyzing and Planning: Using the data stored in data warehouse.
c) Broad cast publishing: To send the information to the employees using email, fax etc.
d) Reporting: BI provides the tools for reporting in web-browser, excel etc
It is used to omit replicated entries in the database.
It is done to maintain the large data to ensure the capacity of the application. There are two type of partitioning that is done
a) Logical partitioning
b) Database partitioning
a) It doesn’t contain any type of data.
b) The data comes completely from the information which is provided.
c) By union operations the info providers are connected.
Data flows from a transactional system to the analytical system (BW). DS ( Data Service) on the transactional system needs to be replicated on BW side and attached to info source and update rules respectively.
Interested in learning SAP BI/BW? Well, check our in-depth Sap Bw Training Courses to get a head start in your career.
ODS is mostly used for large storage of data . It is a BW architectural module that appears between Persistent Staging Area and infocubes.
Infocube is a data storage area which has a same structure as that of star schema. If we wish to create a infocube we have to require one fact table surmounted by the four dimensions.
It have two tables:
E table and F i.e. fact table
In info cubes contain 16 dimensions.
a) Info cube doesn’t have any key but ODS have.
b) Info-cube contains refined data while ODS contains detailed level data.
c) ODS is a flat file structure while Info-cube follows Star Schema
The collection of reference data about a measurable event in data warehousing is known as dimensions in BW.
Info-objects are same as that of fields of the source system. Info objects are the characteristics and key figures.
Interested in learning SAP BI/BW? Check our in-depth SAP BI BW Training Courses.
Modelling is the term which is used for designing of data base.
Extended Star Schema is like a star schema in which Master data are kept in a separate tables.
Extractor is the term which is used to dig out the data from the system program.
Fact tables contain the transactional data. It is a group of relations and facts that is foreign key with the dimensions.
There are 4 data types:
Process chain basically automates the data. It automate it like data load, deletion, etc.
The T-codes for Info-Cubes are
a) LISTSCHEMA: Show InfoCube schema
b) LISTCUBE: List viewer for InfoCubes
c) RSDCUBE, RSDCUBED, RSDCUBEM: Start InfoCube editing
The maximum number of characteristics are 248 and key figures are 233.
a. Cross Application (Generic Extractors) : DB View ,Infoset, Function Module
b. Application Specific: BW content FI, HR, CO, SAP CRM, LO cockpit
c. Customer-Generated Extractors: LIS, FI-SL, CO-PA
Yes, an info-object can be converted into an info-provider. To convert this right click on the Info Area and select “ Insert characteristics as data target”.
It is a type of info-provider which contains data from various info-providers and makes it available for reporting purposes.
It is used to convert data types from internal format to external format.
In the start routine we can modify the data packages, when data is loading, While in conversion routine we can’t modify the data.
In transport organizer to unlock the object, go to SE03à , Request TaskàUnlock objects. When you enter your request and select unlock and execute, it will unlock the request.
The transfer routine defines Global Data and Global Checks. It is like the Start Routine.
The types of Multi-providers are:
a) Heterogeneous Multi providers: These info-providers only have a few number of characteristics and key figures. It can be used for the modelling of scenarios by dividing them into sub-scenarios. Each sub-scenario is represented by its own info-provider.
b) Homogeneous Multi providers: It consists of technically identical info-providers, such as infocubes with exactly the same characteristics and key figures.
a) RSPCM: Monitor daily process chains
b) RSPC1: Process Chain Display
c) RSPC: Process Chain Maintenance
d) RZ20: To see log for process chains
T.code is the SARA,and its advantage is to query performance, load performance, minimizes space.
It is one of the most important characteristics for SAP BI .It gives the geographical information like customer, customer sales region and country.
Learn more about our SAP BI Training Videos to get ahead in your career.
B/W statistics is useful in presenting data about the costs linked with the B/W queries, OLAP, aggregative data etc.
Data target administration task includes
a) Complete deletion of data target
b) Construct database statistics
c) Generate Index
d) Delete Index
b) F-Fixed Value
c) H- Hierarchy
d) *- Groups according to characteristics
Slowly changing dimensions is the dimension that changes with time.
To create a connection with LIS info-structure click on LBW0 it will connects LIS info-structures to BW.
Three options are available:
- Additive delta
- New status for changed records
- Full upload
To create classes for BW we have to follow the following steps,
a) Click on post-processing of data sources
b) Click on IMG activity
c) Select BW or any desired node you want to select
d) Click on context menu
e) Press F6 or select “Create node”
After following these steps, a new dialog box will appear, where we can insert our node or class for BW.
TData ware housing is used to define data aggregation hierarchy. It is a logical structure which use ordered levels as a means of organizing data.
To debug errors in SAP GUI we have to follow the path
a) Run Bexanalyzer
b) Business Explorer menu item
c) Installation check
It will show an excel sheet with start button, on clicking on it, it will verify the GUI installation
It is a procedure used to omit the Request IDs and this saves space.
When we want to go back to many records, instead of single value, we use the return table in the Update Routine.
2 partitions are created before the begin date and after the end date.
We should explain as many dimensions as we can and we have to take care that no single dimension crosses the limit of more than 20% of the fact table size.
Rollup is used to pack new DataPackages into the InfoCube aggregates. It is important to perform Rollup because than in InfoCube data will not be available while reporting on the aggregate.
- ABAP routine or a Formula
- Assign a Constant ,
- Assign info object,
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.
The data target administration task are delete index, generate index, construct database statistics, initial fill of new aggregates, etc.
Using BADI we can transform Open Hub data.
Give your career a big boost by going through our Sap BW Certification Course.