Business Objects Administrator Interview Questions - 2

Question: 6

What is a Universe?

Universe is a business - oriented mapping of the data structure found in the database. i.e., tables, columns, join. Universes consists the set of classes, which is the collections of objects. 

A universe is a set of classes and objects intended for a specific application or group of users.

Question: 7

What is an object?

An object is a logical mapping of data or derivation of data in the database. It is the most refined component in a universe. For multidimensional analysis these objects are categorized into three types:

Dimension - Dimension objects are the parameters for analysis. It is basically character information.

Detail - Detail object is the description about the dimensional object. It is not basically focused for analysis.

Measure - Measure object is the numeric information by which the dimension object is measured.

Question: 8

What is join?

Join is the relation that occurs between the two tables that helps to combine into one table.

The purpose of join is that to restrict the Cartesian product.

The join is specified in the Where clause of the sql statement.

The different types of joins are

Equi join - is based on the equality between the values in the column. Because the same column is present in both tables, the join synchronizes the two tables.

Outer join - An outer join links two tables, one of which has rows that do not match those in the common column of the other table.

Theta join - A theta join links tables based on a relationship other than equality between two columns.

Shortcut join - Shortcut joins can be used in schemas containing redundant join paths leading to the same result, regardless of direction.

Question: 9

What are the types of business objects repository domain?

The repository is made up of three domains are:

The security domain

The universe domain

The document domain

Question: 10

Why create a user objects?

Based on one or more existing objects, user objects enable you to:

Make calculations at the database level.

Apply functions to text, for example to capitalize data.

Group data.