BO Interview Questions and Answers Pdf - 1

Question: 1

Explain the repository of the business objects?

A Business Objects repository is a set of data structures stored on a database. A repository makes it possible to share the resources necessary for client/server architecture. To ensure security and manage user resources, a repository comprises three types of domains:

 Universe Domain – Consists of 24 database tables used to store universes.

It stores the universe which you create.

 Document Domain – consists of database table used to store files including Business Objects documents (.rep), List of Value files (.lov),etc.

It stores the documents which can be accessed by multiple users.

 Security Domain – consists of 25 database tables used to store Business Objects users and their permissions.

It stores the information about users, user groups and profiles assigned to the users.

Question: 2

What are the tasks of the universe designer?

The responsibilities that universe designer has

Designing, Creating and maintaining the Universe

Distributing the Created Universes

Question: 3

What is strategy?

The strategy is the script that automatically extracts the structural information from the database or flat file.

Built-in-strategies

External strategies

Question: 4

What is the difference between Built-in-strategies and External strategies?

Built-In-Strategies:

Extracting the joins with tables

Detect cardinalities in joins

Create default classes and objects from the tables

Objects - In this we can set how the objects to be displayed in the universe pane

Joins - In this we can set how the joins between the tables has to be retrieved like matching column names or matching names etc.

Tables - In this it will reads the table structure from the database.

The other strategies are

Setting the number of rows to be retrieved - default 100

The number of row retrieved from database

The execution time of the query based on the number of minutes specified.

The maximum size of the long text objects.

External Strategies:

External strategies are declared in STG section of .PRM file. We can create the external strategy using either sql or flat file.

Question: 5

What is Drill up/down/by/through?

Drill mode allows you to analyze data from different angles and on different levels of detail.

Drill down displays next level of detail in hierarchy.

Drill up goes back up through the hierarchy to display data on less detailed levels.

By using Drill by option you can move to another hierarchy to analyze other data that belongs to a different hierarchy.

Drill Through - If the lowest level of detail you need is not currently available in the report, you can drill through to the database directly from drill mode and get the data you need. You do not have to edit the query in the Query Panel.