SAP BO Administrator Interview Questions and Answers

Q1. What do you understand by Business objects?

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

Q2. Which is latest version available in market for SAP BO?

Ans: SAP BO BI 4.0 SP6 on 30th April 2013

Q3. What are the advantages of using business objects?

Ans: The advantages of Business Objects are:

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

Q4. Difference between SAP BO 3.1 and SAP BO 4.0

Ans:

Q5. What is new features in SAP BO 4.0

Ans:

Q6. What is node ?

Ans: A node is a group of SAP BusinessObjects Business Intelligence platform servers that run on the same host and are managed by the same Server Intelligence Agent (SIA). All servers on a node run under the same user account.

One machine can contain many nodes, so you can run processes under different user accounts. One SIA manages and monitors all of the servers on a node, ensuring they operate properly.

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

Q8. What is Designer.

Ans: 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.

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

Ans: There are two kinds of modes related with designer

1. Workgroup mode
2. Enterprise mode

Q10. Full form of SAP BO components

Ans:

CMC:- Central Management Console

CCM:- Central Configuration Management

CMS:- Central Management Service

Web Application Server port, default 8080
Server Intelligence Agent (SIA) port, default 6410
Central Management Server (CMS) port, default 6400

Q11. What is default url for SAP BO CMC and Infoview ?

Ans:

3.1

CMC Path:- http://hostname/cmcApp/login.jsp

Infoview:- http://hostname/InfoViewApp/login.jsp

4.0

CMC Path:- http://servername/BOE/CMC/

Launch Pad:- http://servername/BOE/BI

Q12. What is location of data folder in SAP BO ?

Ans: C:/Program File/Business Objects/BusinessObjects Enterprise 12.0/

Data folder contain temp data

Logging folder contain log files

Q13. What are new component available in SAP BO 4.0 CMC ?

Ans:

•  User Attribute Management
• Visual Difference
• Auditing
• Monitoring
• Cryptography Key
• Promotion Management
• Version Management

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

Ans: There are two different methods:

1. Drill down
2. Slice and Dice

Q15. Write the kinds of users linked with business objects.

Ans:

• There are various kinds of users
• Supervisor Designer
• Designer
• Graphical Interface
• Supervisor
• General Supervisor
• Versatile User
• End User

Q16. What all data sources are available?

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

Q17. What is Visual Difference?

Ans: Visual Difference enables you to view the differences between two versions of a supported file type(LCM BIAR) or a supported object type(LCM Job) or both. You can use this feature to determine the difference between files or objects to develop and maintain different report types. This feature gives a comparison status between the source and the destination versions. For example, if a previous version of the user

report is accurate and the current version is inaccurate, you can compare and analyze the file to evaluate the exact issue.

Following are the three types of visual difference from which you can detect the file or an object:

1. Removed – In a report, if an element is missing in one of the file versions, the type of difference is shown as Removed. For example, the element could be a row, section instance, or even a block.
2. Modified – In a report, if there is a different value between the source version and the destination version, the type of difference is shown as Modified. For example, the value could be the cell content or the result of a local variable.
3. Inserted – In a report, if there is an element in the destination version but is not present in the source version, the type of difference is shown as Inserted.

Q18. Write the various kind of data providers?

Ans: There are various kinds of data providers are:

• OLAP servers
• Queries over universe
• Personal data files
• SAP
• VBA procedures
• Stored procedures
• Free hand-SQL

Q19. What do you mean by drill mode?

Ans: 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.

Q20. Define personal connection?

Ans: 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.

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

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

Q23. What is custom hierarchies?

Ans: 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.

Q24. How we can create Custom Hierarchies?

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

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

Ans: 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.

Q26. How we can create Custom Hierarchies?

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

Q27.What is Chasm Trap.

Ans: 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.

Q28.How the problem of Chasm Trap be solved?

Ans: It can be solved by two methods:

1. By using SQL parameter in universe which generates SQL statement for each measures and result into a correct output.
2. The second one is involving two joints in different contexts.

Q29. Define Derived tables?

Ans: 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.

Q30. What is User Objects.

Ans: 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.

Q31. Name @functions.

Ans: The @functions are:

• @where
• @ Prompt
• @ script
• @Variable
• @Select

Q32. Write the uses of @functions.

Ans: 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.

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

Ans: Three Domains are there in Business Objects

1. Document
2. Security
3. Universe

Q34. Define secured connection?

Ans: 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.

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

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

Q36. What is Slice in Business Objects.

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

Q37. Differentiate between Dice and Slice.

Ans:

• Dice: It shows the data and removes the data.
• Slice: It reset, rename and delete the blocks.

Q38. Define master/detail report?

Ans: 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.

Q39. What is class?

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

Q40. How many possible ways are there for linking universes?

Ans: There are three ways:

1. The Master approach.
2. The Kernal approach.
3. The Component approach.

Q41. What is data mining?

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

Q42. Write the available Drill modes.

The available Drill modes are;

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

Q43. What is aggregate_awarness?

Ans: 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)

Q44. What is fan trap?

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

Q45. What is Data provider?

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

Q46. At what time we use a context?

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

Q47. Define standard mode?

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

Q48. Write the schema supported by Business Objects Designer.

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

1. Snowflake schema.
2. Star schema
3. Normalized production schema
4. Multistar schema.
5. Data warehouse with aggregates.

Q49. What is Channel?

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

Q50. What are the limitations over user objects?

Ans: 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.

Q55. Name the tasks of universe designer.

Ans: The tasks are:

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

Q56. Write the main components of designer interface.

Ans: The main components are:

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

Q57. Define report bursting?

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

Q58. What is WEBI?

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

Q59. What is the full form of DSS?

Ans: Decision Support Systems.

Q60. What is strategies?

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

Q61. Define universe?

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

Q62. What is secured mode?

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

Q63. Define Drill by?

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

Q64. Define list of values?

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

Q65. What is Auditing in BO 4 ?

Ans: Auditing allows you to keep a record of significant events on servers and applications, which helps give you a picture of what information is being accessed, how it’s being accessed and changed, and who is performing these operations. This information is recorded in a database called the Auditing Data Store (ADS). Once the data is in the ADS, you can design custom reports to suit your needs. You can look for sample universes and reports on the SAP Developer Network.

For the purposes of this chapter, an auditor is a system responsible for recording or storing information on an event, and an auditee is any system responsible for performing an auditable event. There are some circumstances where a single system can perform both functions.

Q66. What is Monitoring in BO 4 ?

Ans: Monitoring allows you to capture the runtime and historical metrics of SAP BusinessObjects Business Intelligence platform servers, for reporting and notification. The monitoring application helps system administrators to identify if an application is functioning normally and if the response times are as expected.

Monitoring allows you to:

• Check the performance of each server
• Check system availability and response time
• View the entire BI platform deployment based on Sever Groups, Service Categories and Enterprise nodes in graphical and tabular format.
• Check health of server

Q67. Which services should be in running mode at time of upgradation of SP and FP in Business Objects ?

Ans:

•  CMC
• Input File Repository
• Output File Repository.

Q68. What is default session time out in SAP BO for web tier ?

Ans: 20 Minute

Q69. What are tables available In CMS database in BO ?

Ans: There are 6 tables on the database level to store the metadata.

1. CMS_VersionInfo
   The table contains the current version of BOE.
2. CMS_InfoObjects6
   This is the main table in the repository. Each row in this table stores a single InfoObject. The table contains the following columns: ObjectID, ParentID, TypeID, OwnerID, Version, LastModifyTime, ScheduleStatus, NextRunTime, CRC, Properties, SI_GUID, SI_CUID, SIRUID, SI_INSTANCE_OBJECT, SI_PLUGIN_OBJECT, SI_TABLE, SI_HIDDEN_OBJECT, SI_NAMEDUSER, SI_RECURRING, SI_RUNNABLE_OBJECT, SI_PSS_SERVICE_ID, ObjName_TR, SI_KEYWORD, SI_KEYWORD_TR, LOV_KEY.
3. CMS_Aliases6
   This table maps the user alias(es) to the corresponding user ID. A user has an alias for each security domain in which they are members. For example, a user may have both a Win NT alias and an LDAP alias. Regardless of the number of aliases a user may have, in the BI Platform each user has only one user ID. The map is stored in a separate table to enable fast logins.
4. CMS_IdNumbers6
   The CMS uses this table to generate unique Object IDs and Type IDs. It has only two rows: an Object ID row and a Type ID row. The CMSs in a cluster use this table when generating unique ID numbers.
   GUIDs, RUIDs and CUID are generated with an algorithm that does not use the database.
5. CMS_Relationships6
   Relationship tables are used to store the relations between InfoObjects. Each row in the table stores one edge in the relation. For example, the relation between a Web Intelligence document and a Universe would be stored in a row in the WebI – Universe Relation table. Each relationship table has these columns:
   Parent Object ID,Child Object ID,Relationship InfoObject ID ( this Default InfoObject “DFO” describes the properties of the link between the two objects.), member, version, ordinal, data. Relationship tables are defined by default objects.
6. CMS_LOCKS6
   This is a auxiliary table of CMS_RELATIONS6

Q70. How to enable tracing without restarting servers ?

Ans: By modifying BO_trace.ini file.