Wednesday, 4 February 2015

43 TOP BO Designer Interview Questions and Answers Part1

1. What is Designer?
The Universe designer uses DESIGNER to design, create and maintain universes for a particular group of users. A universe designer can distribute a universe as a file through the file system, or by exporting it to a repository.
DESIGNER is a Business Objects product intended specifically for you the Universe designer.
It is important to analyze the type of information that the end users at your site will require so that you can develop universes that meet the needs of the user community. This includes the actual reports, information, or results likely to be required by the end users.

2. What is Universe?
A universe is a mapping of the data structure found in databases: tables, columns, joins. A universe is made up of classes, objects and conditions.
A universe is the semantic layer that isolates the end user from the technical issues of the database structure.

3. How do you start creating the universe?
Universe can be created by taking into consideration the type of data and the logical structure of your company’s databases.
Creating of the universe starts with gathering of user requirements, identifying the database tables where the data resides, inserting the db structure to the universe, creating classes and objects from the db tables, and creating measures. Creating the joins between the tables, resolving loops either by creating aliases or contexts. Finally testing & deploying.

4. List some functions to create objects in the universe?
@Aggregate_Aware, @Prompt, @Select, @Variable, Running Sum, Running Count, User Response, String functions, Date functions.

5. How a Universe is identified?
A universe is identified by:
• a file name which consists of up to 8 characters and a .unv extension.
• a long name which consists of up to 35 characters.
• a unique system identifier. This is the identifier assigned by the repository when you export the universe. This identifier is null if you have never exported the universe.

6. How do you distribute a universe?
There are two ways to distribute a universe to end users or another designer:
1) Exporting to Repository (2) Through File system – Moving it as a file through the file Server.

7. What is a Class?
A class is a logical grouping of objects and conditions within a universe.

8. What is an Object?
An object maps to data or a derivation of data in the database.

9. How can we qualify an object?
An object can be qualified as a dimension, a detail, or a measure.
• Dimension objects retrieve character-type data that will provide the basis for analysis in a report.
• A detail object is always associated to one dimension object, on which it provides additional information.
• Measure objects retrieve numeric data that is the result of calculations on data in the database.
A measure object is derived from an aggregate function: Count, Sum, Minimum, or Maximum.

10. What is the difference between conditional objects and other objects?
Conditional objects have a where clause, where normal objects do not have a where clause
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5 

No comments:

Post a Comment