Mr Data Business School | Mr Data Consulting | Mr Data E-Learning | XADAT.NL

Top 25 SAP BO Business Intelligence Specialist Interview Questions by Mr Data 2018

Top Answers to Business Objects Interview Questions

1. Business Objects Characteristics
Criteria Result
Querying and Data analysis Ad-hoc querying & complex data analysis
Total cost of ownership Low due to integrated, scalable, highly available, BI enterprise platform
Ease of use Extremely user friendly, with quick up time
2. What do you understand by Business objects?

Business object detect the solutions for business professionals which could be beneficial to gain data from the corporate database directly from the desktop.

3. Write the advantages of using business objects.
  • There are many advantages of business objects
  • Easy to use
  • Dragging and dropping
  • Graphical interface
  • Business terms that are familiar
  • Powerful reports for a lesser amount of time.

Read this top-rated blog to find out why BusinessObjects is such a sought-after Business Intelligence tool.

Learn Business Object in 18 hrs from experts

4. Write the different products linked with Business Objects.

There are various products related with business objects

  • Broadcast Agent
  • Info View
  • Supervisor
  • Auditor
  • Designer
  • Set Analyzer
  • User module
5. What is Designer.

Designer is a set which is linked with Business object IS utilized by designer for developing and maintaining universe .Here universe is the semantic layer which can resolves the problem of end user issues that are technical related to the database.

6. Name the kinds of modes related with designer and business objects?

There are two kinds of modes related with designer

  • Workgroup mode
  •  Enterprise mode


7. Name different kinds of procedure associated with multidimensional analysis that is inside business objects.

There are two different methods:

  • Drill down
  • Slice and Dice
8. Write the kinds of users linked with business objects.
  • There are various kinds of users
  • Supervisor Designer
  • Designer
  • Graphical Interface
  • Supervisor
  • General Supervisor
  • Versatile User
  • End User
9. What all data sources are available?

BO allows us to review data from various sources. We can use data from RDBMS such as MS SQL server, Oracle, etc.

Become Business Object Certified in 18 hrs.
10. Write the various kind of data providers?

There are various kinds of data providers are:

  • OLAP servers
  • Queries over universe
  • Personal data files
  • SAP
  • VBA procedures
  • Stored procedures
  • Free hand-SQL
11. What do you mean by drill mode?

It is a kind of study mode related to BO and helps in breaching data as well as in presenting data from all the available angles and the levels of details for analyzing the factors which caused the good and bad result.

12. Define personal connection?

It can be made only by one user and can’t be used by the others. The details for same are kept in a PDAC.LSI file.

13. Define Shared connection?

It is opposite of personal connection as it can be used by others also through a server which is common one. In this details of connections are kept in SDAC>LSI file which is there in installation folder.

14. Define secured connection?

It is a kind of connection which overcomes the disadvantages related with the former connection. We can use universe in central repository by secured connection.

15. What is custom hierarchies?

It defines the universe for providing the drill down which is customized and occur between objects from same or different classes taking care of the user requirements.

16. How we can create Custom Hierarchies?

We can create custom hierarchies by clicking on tools then choosing hierarchies from BO designer.

17. What do you understand by context in the universe?

Context can be explained as the specific path of join between a specific group of joins or the tables for the purpose of a specific query.

18. How we can create Custom Hierarchies?

We can create custom hierarchies by clicking on tools then choosing hierarchies from BO designer.

19. What is Chasm Trap.

It is a situation which arises at the time when the value in the fact table get wrong when it is measured from two various fact tables.

20. How the problem of Chasm Trap be solved?

It can be solved by two methods:

  • By using SQL parameter in universe which generates SQL statement for each measures and result into a correct output.
  • The second one is involving two joints in different contexts.
21. Define Derived tables?

They are created in the universe. It is used for complex calculations which can’t be sorted out in the report level. The other useful feature of derived table is that by using dblink we can use the table from other schema.


22. what is User Objects.

It is a universe of classes and objects which is developed by the universe designer. Once the objects which is there in the universe does not matches our requirement, then the user can create his own objects which is known as User objects.

23. Name @functions.

The @functions are:

  • @where
  • @ Prompt
  • @ script
  • @Variable
  • @Select
24. Write the uses of @functions.

The @prompt function tells the end user to write any specific values.
The @script function recovers the result of the Visual Basics for applications macro’s.
The @select function re-used the existing statements.

25. Business object consists of how many domains? Write them.

Three Domains are there in Business Objects

  • Document
  • Security
  • Universe

Take charge of your career by going through our professionally designed Sap Business Object Training Videos.

26. Define secured connection?

It is a kind of connection which overcomes the disadvantages related with the former connection. We can use universe in central repository by secured connection.

27. How we can use one derived table from another?

Using @Derived_table function, we can use one derived table from another. The syntax is:
@derived_table(derived table name)

28. What is Slice in Business Objects.

It is used to reset, rename and omit the blocks. It works with the master or detailed reports.

29. Differentiate between Dice and Slice.
  • Dice: It shows the data and removes the data.
  • Slice: It reset, rename and delete the blocks.
30. Define master/detail report?

Big block of data can be break into small sections by using master or detail report. Replication in values can be avoided by using this.

31. What is class?

Collection of objects in a universe is known as class. Subclasses are derived from the class.

32. How many possible ways are there for linking universes?
  • There are three ways:
  • The Master approach.
  • The Kernal approach.
  • The Component approach.
33. What is data mining?

It is a process by which we can extract the needed details from the database.

34. Write the available Drill modes.

The available Drill modes are;

  • Drill down.
  • Drill up
  • Drill through.
  • Drill by
35. What is aggregate_awarness?

We use aggregate_awarness function to define one object for measures in fact tables when we have a same fact tables in different grains, the syntax is as,
@aggregate_aware(highest_level.lower level)

36. What is fan trap?

A one to many join links to a table which answer with another one to many join links is known as fan trap.

37. What is Data provider?

The question or the data source is known as the data provider.

38. At what time we use a context?

Context is developed when the dimension objects are their in one or both fact tables.

39. Define standard mode?

Only the clients inside the group can be accessed in the standard mode.

40. Write the schema supported by Business Objects Designer.

There are five different schemas supported by Business Objects designer

  • Snowflake schema.
  • Star schema
  • Normalized production schema
  • Multistar schema.
  • Data warehouse with aggregates.
41. What is Channel?

It is to make the users know up-to-date information. Channel is a website with ‘push’ technology.

42. What are the limitations over user objects?

User objects are not common between the end users. It is kept in a specific user object definition file. Hence if any end-user tries to refresh or edit the query contains another user’s user object, it will be routinely cleaned and removed.

Give your career a big boost by going through our Business Objects Certification now!

43. Name the tasks of universe designer.

The tasks are:

  • Creating the universe.
  • Designing the universe.
  • Distributing the universe.
  • Maintaining the universe
44. Write the main components of designer interface.

The main components are:

  •  The structure pane.
  •  The table browser
  •  The universe pane.
45. Define report bursting?

We use report bursting for maintaining the version documents according to the user profiles.

46. What is WEBI?

It  is a solution that is particular in supporting the decisions related with reports, queries,  and analysis.

47. What is the full form of DSS?

Decision Support Systems.

48. What is strategies?

Strategies is used for  extracting automatically structural data from database or  from a flat file.

49. Define universe?

Universe is a group of objects and classes. These objects and classes will be projected for an application or a set of users.

50. What is secured mode?

Secured mode blocked the contact of specific users over specific commands.

51. Define Drill by?

Drill by is used to move to other hierarchy and examine the other data, which belongs to another hierarchy.

52. Define list of values?

It is a file which has the data values linked with an object.

Looking to master SAP Business Objects? Go through the Business Objects Training.

business intelligence specialist interview questions, sql interview questions for business intelligence analyst, business intelligence developer interview questions, common business intelligence questions, business intelligence manager interview questions, entry level business intelligence interview questions, best business intelligence interview questions, business intelligence analyst interview questions,

accenture business objects interview questions, bo universe interview questions, sap bo webi interview questions, sap bo admin interview questions, sap bo idt interview questions, sap bo 4.1 admin interview questions, business objects interview questions for 4 years experience, sap bo scenario based questions

Print Friendly, PDF & Email
User Avatar