If you're looking for SAP BW Interview Questions & Answers for Experienced & Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research SAP BW has a market share of about 22.2%. So, You still have the opportunity to move ahead in your career in SAP BW. Mindmajix offers advanced SAP BW Interview Questions 2018 that helps you in cracking your interview & acquire dream career as SAP BW Developer.
Q1) How can you put separate Star and the Conversion Routine?
|S.No||Star Routine||Conversion Routine|
|1||Data packages can be modified anytime||They cannot be modified|
|2||Support only internal format||Support both internal and external format in majority of applications|
|3||Routines are bounded||Routines don’t have restriction on them in any of the assigned task|
Q2) What exactly do you know about the SAP BW?
It is actually a data warehouse application that has some of the tremendous features in it. The fact is every business needs to maintain the data in the most reliable manner and this is one of the best available tools to enable businesses for the same. It can simply help organizations in data reporting, formatting, analysis, as well as in important decision making. Data can also be accessed easily from all the SAP applications and in case the need felt, from other business as well.
Q3) Tell something about the extended star schema?
In the SAP environment, the users are free to keep the master data in a separate table. The same is considered as the Extended Star Schema. Generally in Star Schema, the Dimension and the Fact tables are responsible for the accomplished tasks.
Q4) What are extractors? Name a few which are used commonly in the SAP BW?
Many times there is a need to extract the data from the system programmer. This task generally needs a lot of time and efforts too. With the help of an extractor, it can be accomplished very easily and in a proper time frame. The users are free to consider them in the SAP Business Warehouse easily. A few which are used commonly are as under:
1. Customer Generated Extractors
2. Application Specific Attractors
3. Cross Application Extractors
Q5) What is the significance of Data integrity according to you?
While dealing with data, there are strong chances that similar files are present at multiple locations. They can create a lot of issues. Also, they generally acquire more space. The users have to face a lot of problems with the duplicate entries. Therefore this approach data integrity is considered when it comes to dealing the data in a warehouse. It simply makes sure that no duplicate entries exist in the warehouse.
Q6) Can you name a method which can be considered for the purpose of the purpose of improving the efficiency of the application in the SAP environment?
This can be done by making use of an approach known as Table Partition. SAP allows 2 types of partition and they are Logical and Database.
Q7) What is Geographical Information in the SAP BW and for what purpose it is used commonly?
Geographical Information generally consists of information related to a customer, origin, region of the sales, transaction history and a lot more. It can be accessed through a geographical system, named as BEx.
Q8) Tell something you know about the dimension in the Warehouse and how it can be optimized?
Generally, the Data Warehouse has a group of reference information about any activity. The same is considered as a dimension in the warehouse. For optimization, the users have to make sure that there are no dynamic characters remains present in the dimension and there should also be a strict upper limit on the size of the same.
Q9) Tell something about the Operational Data Store?
There are applications in which the data need to be stored in a very detailed manner and this is exactly where this approach is considered. Basically, it is a Business Warehouse architecture that is responsible for the reporting. It usually remains present in the Persistent Staging Area. It doesn’t have any application with the star schema and is actually a tool considered for reporting than dimensional analysis. For changing the data stored in this architecture, sometimes there is a need to change the records.
Q10) How can you change the format of internal data to the external data in SAP BW?
For this, a direct option named Conversion Routine can be accessed
Subscribe to our youtube channel to get new updates..!
Q11) Compare Infocubes with Operational Data Store?
- The level of data in the ODS is very high and every single detailed about the same can be grabbed easily. On the other side, not many details are present in the Infocubes about the data.
- It is possible to control the ODS with a key whereas the same is not possible in case of an Infocube
- ODS is a flat structure but Infocube is a 16 dimensional approach
- Under a Cube, there can be multiple ODS. Generally, it can be said that Infocube can have data which is derived generally from the ODS.
Q12) What is the significance of modeling approach in Data Warehouse?
It is basically an approach that is considered for the purpose of database designing. It’s nothing but the schema that actually decides the design for the database. A schema is nothing but a proper representation of tables and how they are related to one another.
Q13) Can you create data storage area in the SAP BW?
Yes, this is possible and generally it is called as Infocube. There are generally two tables which are present in it and they are called as Dimensional Table and the Fact Table.
Q14) Can you name a few important tasks which are essential in the data warehousing and management of same?
- Collection integration, as well as management of the data and the concerned tasks
- Making effective plans and analyzing the situations with the help of data stored
- Next important task is reporting. There are many tools in SAP BW application that are useful in this matter and enable user to keep up the pace even when the data is present on the browser or in the excel.
- Next important module is to assure broad cast publishing
- Making sure of security is the next big thing as privacy always matters for any businesses when it comes to dealing with the data whether structured or unstructured
Q15) What exactly do you know about the term Data Flow in the Business Intelligence or Business Warehouse?
It defines the path adopted by the data and how it reaches from one specific location to another in a domain or in a warehouse. There are various rules and regulations that govern the control over the same. Generally the flow is from a transactional to an analytical system.
Q16) Name a few transaction codes that can be deployed for the process chain without any restriction?
These are Process Chain Display, Monitor Daily Process and Process Chain Maintenance
Q17) What is Process chain and when you can use the same in the Data Warehouse?
It is basically an approach that is useful when it comes to automating the loading process of the date. Several important processes such as Indices, Data Load, as well as the deletion can be automated provided some basic conditions are met and the best thing is the users doesn’t have a lot of concern with the type of data you generally make use of.
Q18) Name any two important Transactions codes used for the purpose of providing the information?
Q19) Is it possible for the users to convert the package group into a Process Chain? If so, how?
Yes, this can be done easily. For this, the user has to first make a double click on the group defining the info. Next is to open the Process Chain Management option from it. After this, the users have to type the name and the description post which the task is done automatically.
Q20) While handling some important tasks in the Business Warehouse, what if the Info providers required are not sufficient? What would be your action?
Well, in such a situation, it is possible for the users to simply use the Info-objects as Info-providers.
Q21) Can you tell something about the Multi-provider in the SAP and how it is useful for the users?
It is basically an info-provider that consists of data from the info-providers used for other tasks. One of the main aims of this is to make sure that data remain available reliably for the reporting purpose. Some of the things that make it useful for the users are:
1. The source of data is from the Info providers that are dedicated to a specific task.
2. They themselves doesn’t contain any sort of data present in them
3. There are basic union operators which make sure that the Info-providers remains connected to one another
4. They are useful in assuring effective reporting and make sure they can be run anytime for testing or any other purpose
Q22) In a transport organizer, how you can unlock an object?
The users need to open the SEO3a Request Task File and from where the restriction can be removed
Q23) Name two types of Multiproviders and compare them to each other?
These are Homogenous and Heterogeneous. In homogenous, there are info-providers which are similar to one another in terms of all their technical specifications and other technical details. They can also have similar key figures and the characteristics.
On the other side Heterogeneous are the ones which are ones which have only a limited number of identical characters as well as the key figures. It can be used for the modeling while the homogenous cannot be considered for this task. All the scenarios can easily be divided into the sub-categories and have their own dedicated info-provider.
Q24) What exactly do you know about the Business Warehouse statistics?
There are a number of cubes present in the SAP and they are considered for the purpose of measuring the performance of data loading and query handling. All the data in the Warehouse can be shown or can be displayed with the help of this approach. Generally, it keeps an eye on the overall time queries take to accomplish a task or how quick they are responded.
Q25) What is generally included in the Data Target Administrative task?
All the information regarding the database statics, Indexes, Info-cube comparison, Deleting the data target, as well as maintenance can be located in the Data target Administrative Task.
Q26) Name a few delta options which you can consider while loading from a flat file?
These are Full Upload, Additive Delta and the New Status for changed records
Q27) Can you tell something about the Data Ware-house Hierarchy?
It is basically an approach that is considered when it comes to defining the data aggregation. Basically, it’s a logical structure and the best thing is the users are free to consider it for the purpose of data organization. The common example of this approach is the time dimension hierarchy.
Q28) What is compression in the Data Warehouse?
It is basically a procedure that is considered for the purpose of eliminating the additional ID’s. Its main aim is to make sure that the maximum space remains available on the warehouse so that maximum amount of data can be stored. Compression is basically a useful approach with the help of which the users can make sure that no duplicate or unused ID’s exists in the warehouse environment which can sometime slow down the system performance.
Q29) What do you mean by the term Rollup in the SAP BW?
Generally, this approach is considered when it comes to packing the new data packages in the Info-cubes. This is generally done because the entire data in the Infocube doesn’t remains available during the reporting processes.
Q30) What is Dashboard in SAP BW and how it is created?
It is basically a collection of views, groups, as well as reports. It can also be considered as the graphical reporting interface. It is possible to create the same with the help of a Web Application Designer. The entire content can be displayed on a screen quickly.
Q31) What can be used for connecting SAP BW with an BEx query?
BICS - Business Intelligence Consumer Service can used for connectivity of BI tools for connecting to the BEx queries with the SAP BW system.
Q32) Explore the SAP BW primary reporting environments?
BEx Analyzer, Web browser, BEx Access, Notepad
Q33) Explain the Purpose of RSTCIPM Transaction
RSTCIPM Transaction can be use for assigning the priority to BI Business Content Objects
Q34) Which tool used for analyzing the performance of BI OLAP/WHM?
LO Cockpit is used for analyzing BI OLAP/WHM and its performance
Q35) Define InfoArea in SAP BI
SAP BI InfoArea used for grouping the same types of objects together, it also manages the InfoObjects and nfoCubes.