Business Objects Questions and Answers

Business Objects Designer  Questions Answers.

Describe BO Designer
Answer : 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.

What do you mean by Universe?
Answer : 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.

Explain how do you start creating the universe?
Answer : 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.

Name the functions to create objects in the universe?\
Answer : @Aggregate_Aware, @Prompt, @Select, @Variable, Running Sum, Running Count, User Response, String functions, Date functions.

Explain how a Universe is identified?
Answer : 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.

How can you distribute a universe in BO?
Answer : 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.

What do you mean by a Class?A class is a logical grouping of objects and conditions within a universe.

Define an Object?
Answer : An object maps to data or a derivation of data in the database.

Explain how do we qualify an object?
Answer : 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.

Differentiate between conditional objects and other objects?
Answer : Conditional objects have a where clause, where normal objects do not have a where clause

What are the different type of connections Designer provides?
Answer : DESIGNER provides three types of connections: (Tools ? Connections)

• Secured connection (Default): Stores the connection in the security domain of the Business Objects repository to centralize and control access to sensitive or critical data. Designers and supervisors have the right to create this type of connection.
• Shared connection: Specifies that multiple users share the connection. All users who have access to this connection can use it and edit it. If you installed Business Objects in Stand-Alone mode, the connection by default is stored in the sdac.lsi file (LocData subfolder). If you installed Business Objects in Shared mode, the connection by default is stored in the sdac.ssi file (ShData subfolder). Designers and users have the right to create this type of connection.
• Personal connection: Specifies that the connection belong to the user who defined it. Other users cannot use or modify the connection. If you installed Business Objects in Stand-Alone mode, the connection by default is stored in the pdac.lsi file (LocData subfolder). If you installed BusinessObjects in Shared mode, the connection by default is stored in the pdac.ssi file (ShData subfolder). Designers and users have the right to create this type of connection.

What do you mean by Universe parameters?
Answer : These parameters define the universe. They are Definition, Summary, Strategies, Controls, SQL and Links.

• Summary : Statistics of objects, joins, conditions, classes, contexts, hierarchies and alias in a universe. We get it from the Summary tab of the Universe parameters or File ? Parameters.
• Controls : The Control settings allow to limit the size of the result set and the execution time of queries.
• SQL : These parameter controls the query (allows use of subqueries, allows use of union, intersect and minus operators) and SQL generation options for the universe.
• Links : This links tab is used with dynamically linked universes.

Related Posts