Top 50 SAP

BO Interview

Questions
and Answers
SAP BO
“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:-

P  erformance 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

Top 50 SAP BO Interview Questions and Answers

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
A Business object can be de ned as an Integrated Analysis, reporting, and query to nd 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.

Top 50 SAP BO Interview Questions and Answers

Q.2 What are the Pros/Advantages of using SAP Business Objects?
The Pros & Advantages of using SAP Business Objects are as follows:-

I ts 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 Di erent Products related to SAP Business objects
Following are the various kinds of Products related to business objects:-

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

Top 50 SAP BO Interview Questions and Answers

Q.4 De ne Designer
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?
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.
Following are the two different methods related to multidimensional analysis available inside
BO:-

S  lice and Dice

 Drill down
Q.7 List out the kinds of users associated with the business objects.
Following are the different kinds of users associated with the BO:-

  eneral Supervisor
G
 Supervisor
 Graphical interface
 Designer
 Supervisor designer
 End users
 Versatile users

Top 50 SAP BO Interview Questions and Answers

Q.8 What are the various data sources available?
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 De ne the kind of data providers?

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

S  tored procedures
 Queries over universe
 Freehand- SQL
 VBA procedures
 SAP
 OLAP
 Personal data les
Q.10 What is Drill Mode?
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?

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 le.

Q.12 What is Shared Connection?

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.

Top 50 SAP BO Interview Questions and Answers

Q.13 What is the secured connection?
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 De ne Custom Hierarchies?

The purpose of Custom Hierarchies is to de ne 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?

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

Q.16 De ne a context in the Universe?

A particular path of the joining between a speci c group of joins or the tables for the purpose of
a particular query can be de ned 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?

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.

Top 50 SAP BO Interview Questions and Answers

Q.18 De ne a Chasm Trap
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?

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

I n 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?
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 dif cult 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 De ne User Objects.

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.

Top 50 SAP BO Interview Questions and Answers

Q.22 List out the @ functions

Following are the @functions

  Aggregate_Aware
@
 @Script
 @Select
 @Variable
 @where
 @Prompt
Q.23 What is the use of @functions?
To enter any speci c value, the end-user uses @functions.

 To enter any speci c 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.

Top 50 SAP BO Interview Questions and Answers

Q.24 What Domains are there in Business Objects?
The following are three Domains in Business Objects:-

S  ecurity
 Document
 Universe
Q.25 How one can access one derived table from another?
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 De ne Slice in Business Objects.

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 Di erentiate Dice and Slice.

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.

Top 50 SAP BO Interview Questions and Answers

Q.28 What is a master/detail report?
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 De ne a class.
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?
Following are the three approaches available for linking the universes and they are:

T  he Kernal approach.
 The Master approach.
 The Component approach.
Q.31 What is data mining?
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.

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

  rill up.
D
 Drill down.
 Drill by.
 Drill through.
Q.33 De ne Aggregate_Awarness.
 Aggregate_Awarness function is used to de ne 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)

Top 50 SAP BO Interview Questions and Answers

Q.34 De ne the term fan trap?
Fan Trap is a one-to-many join, links to a table that responds with another one to many join links.

Q.35 De ne Data provider.

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

Q.36 When can we use context?

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

Q.37 What is the standard mode?

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

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

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

There are ve different schemas supported by Business Objects designer are these:-

s  tar schema.
 Snow ake Schema
 Multistar Schema
 Normalized production schema.
 Data warehouse with aggregates.

Q.39 What is a Channel?

 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.

Top 50 SAP BO Interview Questions and Answers

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

User objects are not shared/ sharable with other end users. It is stored in a speci c user object
de nition le, 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?

The tasks consist of the following:-

  esigning the universe.

D
 Creating the universe.
 Maintaining the universe.
 Distributing the universe
Q.42 What are the main components of the designer interface.
The main components of the designer consist of:-

T  he table browser.
 The structure pane.
 The universe pane.
Q.43 What is called a report bursting?

Report bursting is used to maintain the version documents according to the user pro les.

Q.44 De ne WEBI.
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?

Decision Support Systems.

Q.46 De ne strategies.
Strategies are also called scripts, to automatically extract structural information from a database
or from a at le.

Top 50 SAP BO Interview Questions and Answers

Q.47 De ne the universe.
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 De ne secured mode.

A Secured mode is a mode that restricts the access of speci c users over speci c commands.

Q.49 What is Drill by?

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?

A le 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 bene ts 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.

T  he global Business Intelligence Industry is growing at a high rate every year

 The average salary of a Certi ed 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

Top 50 SAP BO Interview Questions and Answers

Conclusion:–
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. 

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

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

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

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

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

-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 Certi ed SAP BO Training course.

Top 50 SAP BO Interview Questions and Answers

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

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

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

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

       –

INDIA 
Henry Harvin House
B-12, Sector- 6, Noida
Uttar Pradesh 201301
Call Us:- +91-9891953953

https://www.henryharvin.com/

Top 50 SAP BO Interview Questions and Answers