Business Objects Interview Questions

Q. What the term Business Objects means?
Considered as integrated analysis, Business Objects help in reporting and query to find solutions for some business professionals that can prove helpful for them for recovering data from the corporate databases from the desktop in a direct manner. Furthermore, this recovered info can be analysed and presented in a document that of business objects. Apart from this, it can prove beneficial as an OLAP tool by the management at the high level as the most important part of the decision support systems.

Q. What are the advantages of using Business Objects?
Arrays of advantages are there in making use of Business Objects. These are as follows:

1. Graphical Interface
2. Dragging and Dropping
3. Terms those are familiar in business 
4. User friendliness
5. Powerful reports for short span of time
6. Use of documents on basis of an enterprise using Webl

Q. Explain Designer.
Related with Business Objects IS, it is module that is employed by designers to create and maintain universes. To brief, Universes is known as semantic layer isolating the end users from an array of issues that are not only technical but are also related with the database structure. Universe designers have the opportunity to distribute various universes to the end users as file all the way through the files system or by exporting such files to the storehouse. 

Q. Name different products that are related with Business Objects.
A wide range of products are related with the Business Objects. These are as follows:

1. Designer 
2. User Module 
3. Supervisor 
4. Set Analyzer
5. Auditor
6. Info View 
7. Broadcast Agent
8. Software Development Kit related to Business Objects 

Q. List out the kinds of modes related with Business Objects and Designer.
There are two kinds of modes linked with the Business Objects and Designer platforms:

1. Workgroup Mode
2. Enterprise Mode

Q. Name various kinds of users related with Business Objects.
There are many kinds of users that are associated with Business Objects. These are as follows:

1. Graphical Interface 
2. Designer 
3. General Supervisor 
4. End user
5. Supervisor
6. Supervisor Designer 
7. Versatile User 

Q. List out the various available data resources.
You can access the data from a wide range of sources using Business Objects. These are: 

1. Oracle 
2. MS SQL Server
3.  IBM DB2

Business Objects training is an integrated query, reporting and analysis solution for business professionals.Learn Business Objects!

Q. What is a Drill Mode?
Drill Mode is a kind of analysis mode that is related with business objects and is prove helpful in breaking down the data and also in viewing data from almost all the levels of detail and from the angles to discover the factor that is responsible for causing good or bad result.

Q. Name different types of Drill Modes available.
Helping you in analysing data from different state of details and angles, there are various available Drill Modes like:

1. Drill Up
2. Drill Down
3. Drill Through
4. Drill By

Q. List out the various kinds of data providers for Business Objects.
For Business Objects, there are different kinds of data providers available. They are as follows:

2. OLAP servers
3. Stored Procedures 
4. VBA procedures 
5. Personal data files
6. Free hand –SQL
7. Queries over universe 

Q. Define a personal connection.
 A personal connection is formed by one user as well as can’t be employed by other users. The details of the connection are usually stored in PADC.LSI file.

Q. Define a Shared connection.
Through a shred server, a shared connection can be used by other users. All the details of the connection are accumulated in SDAC.LSI file that can be found in the Business Objects installation folder. 

Q. Define a secured connection.
Through a secured connection rights can be set on documents and objects. With the help of a secured connection, universes can be easily exported to the central repository. It can prove helpful in overcoming various limitations that are related with the other connections. The parameters associated with this connection saved usually within CMS.

Q. What are custom hierarchies?
The custom hierarchies are used to define the universe for assisting drill down that is not only customized but can also occur between objects from same or different classes taking into consideration the user requirements.

Q. What is the process of creating custom hierarchies?
One can create custom hierarchies with the help of path tools such as hierarchies in BO designer.

Q. What is a Chasm Trap?
It is a condition that occurs when the values within the fact table get overblown at the values measurement time from different fact tables by taking into consideration the dimensions that are available in the dimension table.

Q. What is the procedure of solving Chasm Trap?
By using two different methods, Chasm trap can be solved. They are as follows:
1. In the SQL parameters case in universe, the option creates a wide range of queries for each and every measure that requires to be selected. This assists in forming SQL statement for all measures and provides the accurate results.
2. To solve the Chasm trap, another approach that can be followed is the inclusion of two joints in different contexts. With this, the problem can be solved with the help of generating two queries in synchronized forms. 

Q. Name different @functions.
There are different @functions. They are as follows:

1. @Select
2. @Script 
3. @Aggregate_Aware
4. @Variable
5. @Where
6. @Prompt 

Q. Explain the various uses of @functions.
By using @Script function, an applications visual basics macro results can be recovered. The @prompt function asks over to enter any specific value to the end user. By using @Select function, an existing SELECT statement for the available ones can be re used. With the @Variable function, the value assigned for a name or variable can be referenced. Using @Where function, an existing object can be re used.

Q. Name different Domains used in Business Objects.
Three different types of domains are there in Business Objects. They are as follows:

1. Universe 
2. Document 
3. Security

Q. Define the process of accessing one derived table from another.
One derived table can be accessed from another with the help of @Derived_table function. The syntax is as follows:
@derived_table (used as the derived table name)

Q. Explain the role of Slice in Business Objects.
Slice works with the detail or master reports. Also, it is used for renaming, resetting and deleting the blocks.

Q. Explain the difference between Slice and Dice.
Slice helps in renaming, resetting and deleting the blocks, Dice helps in displaying and removing the data. In other sense, Slice works with the detail/master report, while Dice helps in turning the tables and crosstabs into charts and charts in crosstabs/tables.

Q. What is a class?
It is the compilation of objects in a universe. A hierarchy can be formed with the help of these classes as subclasses can be derived from classes.

Q. What do you mean by data mining?
It is a process by which one can extract the needed details out from the database, which can be made available to make conclusions.

Q. Define fan trap.
The term fan trap helps in one to many joining links which further take action with another one to many joining links.

Q. Explain the term data provider.
The data source or the query is known as the data provider.

Q. When a context can be used?
Context is formed when the dimension objects are available in one or both fact tables.

Q. Name various schemas that are supported by Business Objects designer.
There are 5 different schemas that are supported by Business Objects designer. These are as follows:

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

Q. What is a standard mode?
Standard mode offers access to only the users those are within the group.


Get Updates on Tech posts, Interview & Certification questions and training schedules