Table of Contents

Download PDF


SAP BO is a reporting and business analysis BI platform, wherein BO allows you to convert the data in a database into information that allows you to make decisions

SAP BO (Business Objects) is the main application that comes under SAP Business Intelligence.  Earlier it was a separate company and in 2007 it was acquired by SAP.

Business Objects is the stationing platform for examining the data and creating reports based on that. It is capable of creating any type of report as per the requirement of its users,  from anywhere ( using the internet also ). It is the main component for helping the organization for following points:-

  • Performance management
  • Access any type of data
  • Access from anywhere
  • creating the plans
  • generating the reports
  • Data analysis
  • Decision making based on the reports
  • Complex to simple,  hierarchical  levels reporting

There is some confusion regarding the dissimilarities between Crystal Reports and SAP Business Objects. Crystal Reports is only a tool to design the report by providing a user-friendly graphical interface. It doesn’t contain all the practices of Business Objects. We can say Crystal Reports is only a sub-section of Business Objects.

The following is the TOP 50 SAP BO Interview Question & Answers

Q.1 What is SAP Business Objects

Ans.A Business object can be defined as an Integrated Analysis, reporting, and query to find a solution to some business professionals. Business Object helps in retrieving the data from the corporate database directly from the desktop. Business Objects provides to document the retrieved information which is easily presented and analyzed.

Q.2 What are the Pros/Advantages of using SAP Business Objects?

SAP FICO Course Training

SAP FICO Course: Ranked Amongst Top 3 Courses | Recognized by Govt of India | Award Winning Institute | ISO 29990:2010 Certified | Live Online Instructor-led Certified SAP FICO Training & Certification

View Course

Ans.The Pros & Advantages of using SAP Business Objects are as follows:-

  • Its easy to operate, hence user friendly.
  • Familiar, simple & easy Business Terms.
  • Its Graphical Interface is very handy.
  • With the use of Webl, deployment of document on an enterprise basis can also be done.
  • Dragging & dropping is simple.
  • Required less time in creating strong & powerful reports.

Q.3 Different Products related to SAP Business objects

Ans.Following are the various kinds of Products related to business objects:-

  • User module
  • Designer
  • Supervisor
  • Auditor
  • Set Analyzer
  • Info view
  • Business Objects- Software Development Kit
  • Broadcast Agent

Q.4 Define Designer

Ans.A module related to Business Objects IS, & used by the designers is called a ‘Designer’.

It is used for creating and maintaining universes. Universes can be considered as a semantic layer that can isolate the end-users from the various issues that are technical and related to the database structure.

Q.5 What Kind of Modes associated with the designer and Business Objects?

Ans.The following are two different types of modes associated with this platform

  • Enterprise mode
  • Working mode

Q.6 List of the various kinds of methods related to multidimensional analysis that is inside business objects.

Ans.Following are the two different methods related to multidimensional analysis available inside BO:-

  • Slice and Dice
  • Drill down

Q.7 List out the kinds of users associated with the business objects.

Ans.Following are the different kinds of users associated with the BO:-

  • General Supervisor
  • Supervisor
  • Graphical interface
  • Designer
  • Supervisor designer
  • End users
  • Versatile users

Q.8 What are the various data sources available?

Ans.SAP Business Objects help you in accessing the data from a variety of sources. The various data sources are RDBMS like Oracle, MS SQL Server, and IBM DB2.

Q.9 Define the kind of data providers?

Ans.Following are the various kinds of data providers available for the SAP Business Objects:-

  • Stored procedures
  • Queries over universe
  • Freehand- SQL
  • VBA procedures
  • SAP
  • OLAP
  • Personal data files

Q.10 What is Drill Mode?

Ans.An analysis mode associated with Business Objects is Drill.  It helps in breaking down data as well as in viewing data from all possible angles and the levels of details for discovering the factor that has caused a good or bad result.

Q.11 What is a Personal Connection?

Ans.A connection created by only a single user and it can’t be made use by others is called a personal connection. Usually, the details regarding such connections can be stored inside PDAC.LSI file.

Q.12 What is Shared Connection?

Ans.A shared Connection is a kind of connection that is usually used by another user via server which is a shared one. The details regarding such connection can be stored within the SDAC>LSI File which can be found within the installation folder of the business objects.

Q.13 What is the secured connection?

Ans.A connection that can be helpful in overcoming the various limitations associated with the former connections is a Secured Connection. The right related to this kind of connection can be set over documents as well as objects. Universes can be brought inside the central repository only by making use of the secured connection. The parameters regarding these connections are usually saved inside the CMS.

Q.14 Define Custom Hierarchies?

Ans.The purpose of Custom Hierarchies is to define the Universe for facilitating drill down that is customized, and can happen between objects from different or same classes considering the requirements of users.

Q.15 How can Custom Hierarchies be created?

Ans.Such hierarchies can be created by following the path tools->hierarchies in Business Objects designer.

Q.16 Define a context in the Universe?

Ans.A particular path of the joining between a specific group of joins or the tables for the purpose of a particular query can be defined as a Context. An object particularly found inside the column of the table, and belonging to this particular context is supposed to be compatible with all the different kinds of objects belonging to the same context.

In that case, objects that are from the various kinds of context, different kinds of SQL can be generated, and the results can be merged inside the micro cube. It makes sure that there is no incorrect result associated with a loop or any other kind of issues related to joining path.

Q. 17 How a Context be created?

Ans.To create Context make use of features associated with the context or by using manual procedures Context can be created.  It is usually created by making use of logical calculations or based on the business requirements. The detect context may not be that useful in the case, and so it should be done by making use of the manual procedures.

Q.18 Define a Chasm Trap

Ans.A condition that arises when the values inside the fact table get increased at the time of measuring the values from two different fact tables by considering the dimensions under the dimension table.

Q.19 How can Chasm Trap be solved?

Ans.By using these two different methods Chasm Trap can be solved:-

  • In the case of SQL parameters in the universe, the option generates various queries for each and every measures that needs to be selected. This is helpful in generating a SQL statement for every measure and provides the correct results.
  • Another approach is to include two joints in different context, where the problem will get solved by bringing forth two synchronized questions.

Q.20 What are the utilities of Derived tables?

Ans.Derived tables are created in the universe by using SQL queires from the database level. The columns selected in the query are the columns of the derived table. Derived Table can be used in the tricky calculations which are difficult to be achieved in the report levels. Another use of Derived Tables is using a dblink, tables can be accessed from a different schema.

Q.21 Define User Objects.

Ans.A Universe designer creates a  universe of classes and objects under User Objects. Once the objects consisted of the universe doesn’t match your requirements, then the user can create his own objects called User Objects.

 Q.22 List out the @ functions

Ans.Following are the @functions

  • @Aggregate_Aware
  • @Script
  • @Select
  • @Variable
  • @where
  • @Prompt

Q.23 What is the use of @functions?

Ans.To enter any specific value, the end-user uses @functions.

 To enter any specific values the @prompt function is used by the end-user.

 The visual basics for applications macro’s results will be recovered by using the @Script function.

 An existing statement can be re-used by using the @Select function.

Q.24 What Domains are there in Business Objects?

Ans.The following are three Domains in Business Objects:-

  • Security
  • Document
  • Universe

Q.25 How one can access one derived table from another?

Ans.To access one derived table from another @Derived_table function is to be used.

@derived_table(the derived table name)with this syntax.

Q.26 Define Slice in Business Objects.

Ans.Slice works with the master or detail reports and the purpose of Slice in Business Objects is used to rename, reset and delete the blocks.

Q.27 Differentiate Dice and Slice.

Ans.Slice is used to renames, reset and delete the blocks. It works with the master/detail report. Whereas Dice is used to displays the data and remove the data.  Slice turns the crosstabs and tables into charts and vice versa.

Q.28 What is a master/detail report?

Ans.Mater/ Detail report helps large blocks of data to split into sections. Value repetition can be avoided by using this, and also the subtotals can be displayed in it.

Q.29 Define a class.

Ans.The collection of objects in a universe is called a class. Subclasses can be derived from classes and using these classes and the subclasses, hierarchy can be created.

Q.30 How many approaches are available there for linking universes?

Ans.Following are the three approaches available for linking the universes and they are:

  • The Kernal approach.
  • The Master approach.
  • The Component approach.

Q.31 What is data mining?

Ans.A process through which you can extract the required details from the database, which can be made used for making conclusions, is called Data Mining.

Q.32 what are the available Drill modes.

Ans.Following are the available Drill modes, it  helps to analyze data from different angles and different states of details

  • Drill up.
  • Drill down.
  • Drill by.
  • Drill through.

Q.33 Define Aggregate_Awarness.

Ans. Aggregate_Awarness function is used to define one object for measures in fact tables, where we have the same fact tables in different grains. The syntax is as

@aggregate_aware(highest_level.lower level)

Q.34 Define the term fan trap?

Ans.Fan Trap is a one-to-many join, links to a table that responds with another one to many join links.

Q.35 Define Data provider.

Ans.The query ( the web query)or the data source is called the data provider

Q.36 When can we use context?

Ans.When the dimension objects are present in one or both fact tables, a Context is created.

Q.37 What is the standard mode?

Ans. You can design a simple single period or multi-period category scenario by configuring only the chart of accounts hierarchy and the properties used to perform the aggregate calculations in Standard mode.

You define the calculations, periods, dimensional analyses, formulas, and controls, in this mode.

Q.38 What are the schemas supported by Business Objects Designer.

Ans.There are five different schemas supported by Business Objects designer are these:-

  • star schema.
  • Snowflake Schema
  • Multistar Schema
  • Normalized production schema.
  • Data warehouse with aggregates.


Q.39 What is a Channel?

Ans. A website with ‘push’ technology is called a Channel. A channel is to make the users know the complete information. Different Business Objects channels will be associated with a broadcast agent, who can have different channels.

Q.40 What are the restrictions/Limitation over user objects?

Ans.User objects are not shared/ sharable with other end users. It is stored in a specific user object definition file, it will be automatically cleaned and removed if any end-user tries to refresh or edit the query that contains another user’s user object

Q.41 What are the tasks of the universe designer?

Ans.The tasks consist of the following:-

  • Designing the universe.
  • Creating the universe.
  • Maintaining the universe.
  • Distributing the universe

Q.42 What are the main components of the designer interface.

Ans.The main components of the designer consist of:-

  • The table browser.
  • The structure pane.
  • The universe pane.

Q.43 What is called a report bursting?

Ans.Report bursting is used to maintain the version documents according to the user profiles.

Q.44 Define WEBI.

Ans.WEBI is “Web intelligence”, i a solution that is specialized in supporting decisions related to queries, reports, and analysis is called WEBI.

Q.45 Abbreviation of DSS is?

Ans.Decision Support Systems.

Q.46 Define strategies.

Ans.Strategies are also called scripts, to automatically extract structural information from a database or from a flat file.

Q.47 Define the universe.

Ans.The universe is a set of objects and classes, and these objects and classes/ universe will be intended for an application or a group of users.

Q.48 Define secured mode.

Ans.A Secured mode is a mode that restricts the access of specific users over specific commands.

Q.49 What is Drill by?

Ans.we can move to another hierarchy and analyze the other data, which belongs to another hierarchy with the help of Drill by.

Q.50 What is a list of values?

Ans.A file that contains the data values associated with an object is called a List of Values.

About the SAP BO Course

SAP BO Training

Business Object offers an Agile Management System to companies and benefits the company with the execution of Business Intelligence. This course is ideal for anyone who is willing to become a Business Manager.  Web Intelligence 4.1, BO Explorer 4.2, Enchantment of BO 4.1 are included in the curriculum.

The Henry Harvin SAP-BO  Training Course helps the learner with a comprehensive knowledge of the functioning of the Business Intelligence tools of SAP Gain Knowledge about Database Concept, BO universe, BI Reports, Ad Hoc Reports, life-cycle management, Web Intelligence, and more.

  • The global Business Intelligence Industry is growing at a high rate every year
  • The average salary of a Certified SAP Business Object Analyst is over INR 15,00,000/- Per Annum
  • SAP BO arena has job security and is expected to grow in upcoming years


The above-mentioned SAP Business Objects Questions and Answers have been designed specially to make you well aware of the nature of questions you may encounter during your interview for the subject of SAP Business Objects. 

Recommended Reads


Q.1 Is the Henry Harvin SAP BO Course available online?

Ans.Yes, the course is online, can be accessed anywhere.

Q.2what is the course ( Henry Harvin SAP BO training ) offer to learn?

Ans.– The SAP BO Training Course from Henry Harvin offers SAP BO Architecture, Data    Sources theories, Data Warehouse,  WEB Intelligent, and much more.

Q.3 What is the procedure to get enrolled in the SAP BO training course in Henry Harvin?

Ans.-Follow the mentioned steps to get enrolled with Henry Harvin SAP BO Training course:-
1. Get connected with the counsellor, discuss, and get information about the eligibility for the course.
2. Check the batch availability with the counsellor.
3. The next step is to get register yourself for the Certified SAP BO Training course.

Q.4 What is the duration of the Henry Harvin SAP BO Training course?

Ans.-You need to attend 44 hours sessions and also you must gain 44 credits to get eligible for the certificate.

Q.5Will there be Internships/ Projects during the Henry Harvin SAP BO Training course?

Ans.Yes, in order to get experience with the real world, assignments and practical projects are part of the course.


Recommended videos for you


  1. Business analytics which has been a booming field is required in every company. The knowledge is a necessity nowadays and this page has compiled all the best 50 SAP BO most important interview questions and answers in a precise manner. Thanks a lot!

  2. Kanika Verma Reply

    I was searching for interview question and answer for SAP BO And i see this informative blog. thanks for sharing.

  3. nice and informative blog. These questions and answers of SAP BO interview are really very helpful.

  4. This is the best interview guide on SAP Business Objects, I have ever read. Great work!

  5. Krishna Dutta Reply

    It is a nice blog to get aware of the SAP Business Objects interview.

  6. Literally, your blog helped me a lot to crack my interview. Thank you very much and keep sharing such informative and helpful blogs.

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

India Address:

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

FREE 15min Course Guidance Session: