Table of Contents

Download PDF

SAP BW Interview questions, these questions would give you a broad picture to some extent, the kind of questions asked who intend to prepare for the interview.

Introduction

SAPĀ  Business Warehouse (SAP BW) provides tools and functions that enable organizations to achieve the optimization processes, enabling the company to react quickly in line with the market needs. SAP BW provides you with high-performance infrastructure that helps to interpretĀ Ā 

data and identify target-oriented activities on the basis of analyzed data.

Here are the 50 Best SAP BW Interview questions and answers.

Q 1. What is the difference between the star schema and the Extended star schema?

Ans.In the star schema, we have the fact tables and dimensions whereas in the extended star schema we not only have a fact table but also text surrounded by each dimension that is master data.

  • Uses generated numeric keys and aggregates in its own tables for faster access
  • Uses an external hierarchyĀ 
  • Supports multiple languages.
  • Contains master data common to all cubesĀ 
  • SupportsĀ  slowly changing dimensionsĀ Ā 

Q 2. How many dimensions are there in the cube?

Ans.Ā There are max 16 dimensions, 3 are predefined that is time, unit and request,Ā  13 are user-defined dimensions. There should be a minimum of 4 and a maximum of 16 dimensions in a cube.

Q 3. What is the transaction for the administrator workbench?

Ans.Transaction RSA1. RSA11, RSA13 will also take you to a workbench or at the info cube level.Ā 

Q 4. What is ā€ Myself data martā€?

Ans.Feeding one info protocol with another info protocol. “Myself data mart” is feeding data to itself. ALE is used to transfer data. It is created automatically.

Q 5. What is an Aggregate?

Ans.Aggregates are mini cubes. We have a subset of cubesĀ 

It contains less amount of data.

Cube has 1 billion records. we can store less amount of data in the mini cube that works faster to increase the performanceĀ 

Q 6. Can we restrict the key figures?

Ans.Ā In Aggregate there are two ways to reduce the number of characters and not reduce the key figuresĀ 

Q 7. What is the calculated key figure?

Ans.Calculated key figures are used to do complicated mathematical calculations, percentage functions, when we are building the BEx reports, to calculate the quantity and tax.

Q 8. What is the enhancement user exit for BEx reporting?

Ans. RSR00001

Q 9. What is a characteristic variable?

Ans.You can have a dynamic input for the characteristic using characteristic variables if you are developing a sales report for a given product then you will define the variable 0 material

Q 10. What is a Condition?

Ans.If you want to filter any key figure or do a rank based analysis like top 10 customers with more than 10 million sales, we use this feature.

Q11.Ā  What are the data types supported by characters?

Ans.Ā  Ā  Ā  Ā NUMC Ā  Numeric

  • CHAR (upto60) Character
  • DATS Ā  DateĀ 
  • TIMSĀ  Time

Q 12. What are the types of attributes?

Ā  Ā  Ā  Ā  Ā Ans.Display only these attributes are only for display and non-analysisĀ 

  • Navigational attributes these attributes behave like regular characteristic suppose we have customer characteristics with country, navigational attribute you will be able to analyse the data using customer and country.

Q 13. What is meant by compounding?

Ans.Compounding is superior info object which must be combined to define an object.

Q 14.What are the 10 decision points of Data warehousing?

Ā  Ā  Ā  Ā  Ā  Ans.Identify the fact tableĀ 

  • Identify the dimension table
  • Define the attributes of the entities
  • Describe the granularity means howĀ  detailed you want the data to beĀ 
  • Specify the precalculated key figuresĀ 
  • Identify slowly changing dimensionsĀ 
  • Identify aggregates
  • How long is the data be kept
  • How often is the data extracted
  • From which system is the data to be extracted

Q 15. What are the options available in the transfer rule?

Ans.Ā Transfer rules were used in an older version, now we use transformationĀ 

  • Assign an info objectĀ 
    • Assign a constantĀ 
  • ABAP routine

Q 16. What is compression or collapse?

Ans.All regular request is saved to the F table.

When we compress the request ID, data is moved to E- table. E table is the compressed table, this saves space.

If you are using noncumulative key figures in a cube, the cube should be compressed to improve the performance.Ā 

Q 17. To load the data from a file source, what is the requirement in the BW system?

Ans.The Metadata must be available in BI in the form of a data source before the transfer.

Q 18.Ā  In SAP BW is it possible to have multiple data sources have only one info source?Ā 

Ans.Yes, It is possible to have multiple data sources having one info source.Ā 

Ā Q 19. How data is stored in PSA?Ā 

Ans.Ā Ā Data is stored in PSA Tables.

Q 20. What is UD connect in SAP BW system? how does it allow reporting in BI/BW system?

Ans.Universal data UD connect allows to access the relational and multidimensional data source and transfer the data in the form of Flat data. When UD connect is used it transfers multidimensional data into Flat format. UD uses JE connector to allow reporting on SAP and NON SAP data Different BI Java connectors are available for various drivers, protocols as resource adapters –

BI ODBO connector

BI JDBCĀ  connector

BI SAP Query connector

XMLA connector

Q 21. What is the use of DB connection in SAP BW Data acquisition?

Ans.DB connect is used to define other database connection in addition to default connection and these connections are used to transfer data into BI/BW system from tables or views

To connect an external database the prerequisites areĀ 

  • Tools
  • Source application knowledgeĀ 
  • SQL Syntax in DATAbaseĀ 
  • Database functions

Q 22. While loading data from Flat files. when separators are used inconsistently, How this will read in BI load?

Ans.If separators are used inconsistently in a CSV file, the incorrect separator is read as a character and both fields are merged into one field and may be shortened as a result the subsequent fields are no longer in the correct order.

Q 23. What is the use of navigational attributes?

Ans.Navigational attributes is used to drill down in the report.

Q 24. Explain how is the data flow in BW

Ans.Data flow in BW is from transactional system to analytical system. Data source on the transactional system is to be copied to BW and attached to info source and update respectively.

Q 25. What is the partition of Infocube?

Ans.It is a method of dividing table for report optimization. SAP uses fact file partitioning to improve performance. Table partitioning helps to run the report faster as data is stored in relevant partition.

Q 26. What is the use of Rollup?

Ans.This is used to load new Data Package into the Infocube Aggregates. If we do not perform a rollup then new info cube data will not be available while reporting on the aggregate.

Q 27. What do you understand by Start and Update routine?

Ans.Ā The start routine is run for each Data package after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure. It has no return value its purpose is to execute preliminary calculations and to store them in Global data structure. The entire data package in the transfer structure format is used as a parameter for the routine.

Update routinesĀ 

They are defined at the defined object level.It is like the start routine, It is independent of the data source, we can use this to define Global data.

Q 28. Explain the difference between ODS, Infocube and Multi provider?

Ans. ODS

They provide granular data, allow 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.

Multi-provider

It contains physical data and allowĀ to access data from different info providers

Q 29. To perform a union operation on info provider which info provider is used?

Ans.Multi-provider is used to perform a union operation on info provider.

Ā Q 30.In SAP BW, what are the main areas?

Ā  Ā  Ā  Ā  Ans.Data warehouse

  • Analyzing and planning
  • Reporting
  • Broadcast publishing
  • Performance
  • security

Q 31. When you define aggregates, what are the available options?

Ans.H Hierarchy

F Fixed valueĀ 

Blank ..None

These are the options available.

Q 32. Can you convert an Infopackage group into a Process Chain?

Ans.Yes, you can double click on the info package group, then click on process chain Maintenance and type in the name and description.

Q 33. Is it possible to convert standard info cube to real time info cube?

Ans.To convert a standard Info cube to real-time info cube there are two optionsĀ 

Convert with loss of transactional dataĀ 

Conversion with retention of transaction data.

Q 34. Can you make an Info object as an Info provider?

Ans.Yes, when you want to report on characteristics or master data, you can make them as an Info provider.

Q 35.How do you create a Real-time Info cube in the administrator workbench?Ā 

Ans.A real-time info cube can be created using the real-time indicator check box.

Q 36. What are the non-cumulative key figures?

Ans.These are key figures that are not summarized unlike sales, example is headcount and inventory amount. They are always shown in relation to a point in time, here we have a reference with time.Ā Ā 

Ā 

Q 37. What is an Infoset?

Ans.An Info set is an info provider giving data by joining data from different ODS and master data.

Info sets can also be used to combine transactional data with master data. Combine the cubes and master data. Info sets can combine data from your cube and attributes from master data.

We Can use it for advanced improvement performance of reportsĀ 

Q 38. What performance improvement can we do for reporting?

Ā  Ā  Ā  Ans.If the cube has large amount of data build aggregates on it,then we can create lĀ  Ā  Ā  Ā  Ā less amount of data which can perform better.

  • OLAP cache, clear the Olap CacheĀ 
  • Pre calculated web templates can be adopted for easy calculations
  • Use small amount or result data as a starting point of any queries and do the drill downĀ 
  • ā€˜Avoid reporting on ODs for reporting use info set
  • Ā If use exclusion in reporting(> <), The indices are not used.So avoid using exclusion but use inclusion to improve performance
  • Use the read mode ā€˜Hā€™ read when navigating and expanding hierarchyĀ 
  • Use compressions on Infocube since the E table is optimized for queries.
  • Create additional indexes
  • Run Database statistics often
  • Use secondary indexes on ODS active table.
  • Use RSRT transaction to look at the explain plan statementĀ 
  • If you are running a query on Info provider with non cumulative key figure then suppress summary line items( totals)

Q 39. What are the BEx options for characteristics like F4 help for query definition and execution?

Ans.This defines how the data is displayed in the query definition screen or when the query is executed.Options are from the data displayed from masterdata,from master data table from dimension data let us assume you have 100 products in total in your material master,10 products available on cube and in BEx you display a query for 2 products the following options will display different data .

  • Selective data will only display 2 productsĀ 
  • Dimension data will display 10 productsĀ 
  • From master data will display 100 products

Q 40.Ā  What is the difference between amount /quantity and number type key figures?

Ans.Amount /Quantity is always combined with units, for example, sales will be linked to currency and inventory will be linked to quantity in units. In your design, if you donā€™t need units then you should use number or integer for better performannce.

Q 41. What is the use of the time distribution option in the update rule?Ā 

Ans.This option is used to update data according to time for example if the source contains calendar week and the target contains calendar day. The data get split into each calendar day

Q 42. What are the types ofĀ  Key figure?

Ans.Amount

Quantity

Numeric
Integer

Date and time, amount, quantity should be followed with the unit.

Q 43. How would you optimize dimensions?

Ans.Use as many dimensions as possible for performance improvement for example assume that you have 100 products and 200 customers

Option 1: make one dimension for both, the size of the dimension will be 20000 (100×200)

Option 2: Make individual dimension one for the product(100 rows) and one for customers (200 rows )the total number of rows in both dimensions will be 300

Obviously, option 2 is better

We are segregating the number of characteristic in two dimensions it would be better to do the process.

Q 44. What is a Line item or degenerate dimension?

Ans.If the size of the cube is the same as the size of the fact table you define that dimension as a line item dimension for example if the characteristic in one dimension are 100Ā  and 100 key figure in Fact table that particular dimension is called Line item dimension.

Only one characteristic is allowed per line dimensionĀ 

Q 45. What is marker in Non cumulative cubes?Ā 

Ans.Non-cumulative cubes which do not have a reference to time, Non-cumulative cubes are stored using a marker for the current period. A marker is nothing but a pointer referring to a time period for example an inventory cube marker may refer to the inventory levels as of yesterday.

Q 46. What is the use of a colon ā€˜:ā€™ as an authorisation value?Ā 

Ā  Ā  Ā  Ans.It enables queries that do not contain an authorization relevant object that haveĀ  Ā  Ā  Ā  Ā  been checked into the info cubeĀ 

  • It allows the summary data to be displayed if the user does not have access to detailed data.

Q 47. What is the InfoObject catalog?

Ans.Info objects are created in Info object catalog. It is possible that an Info object can be assigned to a different info catalog.

Q 48. What all data sourceĀ  you have used to acquire data inSAP BW system?

Ā  Ā  Ā  Ā  Ā  Ans.SAP Systems (SAP Applications /SAPECC)

  • Relational database (Oracle,SQLserver,etc)
  • Flat file (Excel,Notepad)
  • Multidimensional Source systemsĀ 

(Universe using UDI connector)

  • Web services that transfer the data to BI by means of push.

Q 49.Ā  What is the maximum number of key figures and characteristics?

Ans.The maximum number of key figure is 233 and characteristics are 248.

Q 50. How will you debug errors with SAP GUI?

Ans.To debug errors inSAP GUIĀ  you have to follow the path as mentioned

  • Run BexanalyzerĀ 
  • Business Explorer menu item
  • Installation checkĀ 

This will take you to an Excel sheet where clicking on the start button it will verify the GUI installation and if you find an error fix it or reinstall it.

Henry Harvin

henry harvin logo

Henry Harvin SAP BW Training

SAP ERP has developed SAP Business Warehouse. It performs with the help of BI tools. SAP BW helps in the multidimensional analysis of data for a detailed understanding of business activities. SAP BW has extensive security tools which ensures that the data is exposed to only those at the higher levels with valid credentials, and the critical data about an organization is always protected. Data Warehousing Workbench is the central tool for task related to Data Warehousing.

Why Learn SAP BW?

  • Learn to extractĀ  data and use it to benefit the business for the
  • SAP BW skilled professionalsare offered high salary
  • It offersĀ  Job Opportunities with skills ofĀ  SAP BW Consultant

IND: +91 9891953953 | [email protected]

Check Henry HarvinĀ  SAP CoursesĀ 

SAP FICO CourseĀ |Ā SAP MM COURSEĀ |Ā SAP HR Course |Ā SAP Hana CourseĀ |Ā SAP ABAP CourseĀ |Ā SAP Ariba TrainingĀ |

Cities in India where Henry Harvin SAP FICO Course is provided:

Delhi,Ā Hyderabad,Ā Mumbai,Ā Gurgaon,Ā Pune,Ā Indore,Ā Online,Ā Bangalore,Ā Kolkata,Ā Chennai

ConclusionĀ 

SAP BW is a perfect start for your career as SAP has a huge market share in BI/BW.Ā  So the people with skills in this area are always in high demand. SAP BW is a data warehousing tool and you can create reports over the data for reporting purpose. You can aggregate the data from different systems and show it in a single report. These reports help decision-makers in organizations in taking major decisions.

SAP BW Consultant’s demand is very high on job portals.

Hope these 50 Best SAP BW Interview questions and answers help you for grabbing the opportunity!

Ā Recommended Reads

FAQs

Q1. Tell me something about yourself?

Ans.Rationale: This answer sets the tone for the interview, they want to know how you react to uncomfortable questions. It’s open-ended and reveals what matters to you.
Ā Prepare properly for the interview, politely answer, exchange pleasantries,describe about your work efficiency,highest qualification.Ā 

Q2 . Why should I hire you?

Ans.As a fresher I am a quick learner, till now I only have detailed theoretical knowledge, This opportunity will certainly convert implementing them practically. Given the opportunity, I will do my best.
If you are experienced explain to them your achievements and awards received and projects with the client.Ā 

Q3. How do you feel working on weekends?

Ans.To increase your productivity you need to be efficient. I will try to finish my work on weekdays when I am mentally fresh.

Q4.What are the prerequisites before you go for an interview?

Ans.Keep an extra set of Resume hard copyĀ 
Have a folder with all things kept neatly
Prepare well before the interview for any company, know about their vision and mission.
Be comfortable in your Formal attire.
Keep a good body languageĀ 
Be presentableĀ Ā 
Be relevant

Recommended videos for you

SAP FICO Course by Henry HarvinĀ®

Ranks Amongst Top #5 Upskilling Courses of all time in 2021 by India Today

View Course

9 Comments

  1. U have explained almost all the important points of SAP BW in these interview questions and answers. Nice Article

  2. This blog actually helped me in my interview and fortunately, I got selected. Thank you very much for this great interview guide on SAP BW.

  3. Ruby Tyagi Reply

    Very perspective article. It really helped me to get knowledge about SAP BW.

  4. This is one of the best interview guides on SAP BW, I have ever read. All the questions and answers were vividly explained and it was quite easy to understand them. good job!!

  5. This is much appreciated that you presented all the significant and frequently asked questions on SAP BW in such an easily understandable manner, in one blog.

  6. This article was very useful and provided fresh information on the frequently asked questions. It was one of the best blogs on the SAP BW course I ever read.

  7. All the questions and answers are brilliantly explained. It was easy to understand and take up the SAP BW Course

  8. This blog has furnished me with all the details on the SAP BW Course and helped me take the decision on joining the course.

Join the Discussion

Interested in Henry Harvin Blog?
Get Course Membership Worth Rs 6000/-
For Free

Our Career Advisor will give you a call shortly

Someone from India

Just purchased a course

1 minutes ago

Noida Address:

Henry Harvin House, B-12, Sector 6, Noida, Uttar Pradesh 201301

FREE 15min Course Guidance Session:

Henry Harvin Student's Reviews
Henry Harvin Reviews on MouthShut | Henry Harvin Reviews on Ambitionbox |
Henry Harvin Reviews on Glassdoor| Henry Harvin Reviews on Coursereport