can u say be exact difference b/w universe designer & universe builder, as we when newer versions are available from Business Objects. I am just looking for Business Objects Universe Designer Guide, please send me the link where can I get it from?. A Business Objects Universe is the semantic layer that resides between an Only the universe designer needs to know how to write SQL and.

Author: Niramar Sasida
Country: Namibia
Language: English (Spanish)
Genre: Medical
Published (Last): 14 December 2018
Pages: 433
PDF File Size: 12.33 Mb
ePub File Size: 19.52 Mb
ISBN: 170-1-86491-556-8
Downloads: 36791
Price: Free* [*Free Regsitration Required]
Uploader: Samurisar

What to shift your career to Universe Designer? Then we have provided you with the complete details about the Universe Designer Interview Question and Answers on our site page. Cracking an interview at very first attempt need very hard working and should have a good knowledge on all concepts as well. To be short about the Universe Designer is a tool that lets users make, change, organize and deskgner meanings of the universes, stored in the Business Objects repository. For any other further details on Universe Designer jobs and interview question and answers visit our site www.

What Is Business Object? A BO holds a group of instance variables of a class, known as attributes and associations with other business objects.

BO maps objects representing business relationships. BO treats state and behavior as different components as they communicate across various layers in multi-layered architecture.

What Is Bo Main Key? BO Main key contains address of the repository of the domain. Logical grouping of system tables is known as Domain. What Are Linked Universes? Linked Universes are used to link data provided from two different data providers. Alters are used to pay attention to a data block. Filters are used to obtain only required data. Breaks are grouping data without changing the format of the data. Condition is utilized to retrieve data that meet some criteria.

Selection of one hierarchy to another hierarchy is known as drilling. Drilling of data from one hierarchy to another hierarchy is known as Drill Through. Identify the performance of SQL, whether it takes less time or more time than the report. If the time is less than the report time then the problem is with the Universe. Otherwise the problem is with the report. Verify if indexes are built and used.


Verify if aggregate tables can be utilized. Use materialized views which enable the pre-execution of complex joins and stores the data. Outer joins need to be checked properly.

Remove unnecessary outer joins. Delete unnecessary or additional filters on the report. SQL queries are automatically generated at the time of objects are selected.

Upon running, the query is processed pertaining to a database. Local Machine Full Client runs query directly. Data is restricted by implementing Row Level Security in Supervisor. One of the Business Object Components to create Universes. Semantic layer between database and business is established by BO Designer. Semantic layers allow working on reports.

Data cubes can be created by hiding the complexity of the Database. Provides OLAP analysis with reporting. What Is Called Strategy? A simple script to extract structural information from a database.

A BO Designer provides strategies. Creates default classes and objects. The report performance can be improved by the following steps: The below mentioned are requirements of Universe: The connection parameters should be set based on the underlying database.

Use joins in the Universe structure.

Use less SQL functions. Remove unnecessary objects from Universe before moving to production. Ensure LAWs are ticked only for the objects that may be used for reports. Ensure the Data prompts are properly defined. Security bkxi Supervisor level by using Username and Password.

Compare for Cognos Report net and Crystal reports: The Open Document function is used to connect one to one report. Contexts avoid loops in Universe Design: Explain About Locking Universe?

Business Objects universe design tutorial

When a Universe is imported, the Universe needs to be locked Upon clicking on File Import option, select the Universe to import. Once the Universe is double clicked, a lock symbol appears Then only the Universe can be imported. While the lock is in position, no one can modify the universe. What Are Box Ir Tools? Supports to create Universes. Allows analyzing data, creating reports, and performing queries to fetch data. User names and passwords are available in security domain.

Business Object – Universe Designer

It contains the Universe Information in which the universes are exported by users to the repository. It contains the documents that are shared by various users. One level towards up is known as Drill UP. One level towards down is known as Drill Down. Selection of one level directly is known as Drill By. It connects to the appropriate database with the support of a middleware. The web server will process the query, when the query is run using Webi browser. Filters are designed at Universe Level.


Conditions are defined at Report Level. A named formula is referred to as variable.

Conversion of formula into variables is needed when they are used for more than once in a report. Utilize condition as necessary as possible, at the database level. Eliminate the filters as many as possible. Reduce the user variables. Manually selected Database Connections. Classes and Objects to map the data from tables and columns.

Control — for limiting the size of rows and execution time. Parameters for Joins, clauses like where, group by.

Crystal Report is for low and mid range univefse. Report net is for high end analysis.

Signing through web and creating custom report through web is possible in Report net. The function can be used in various methods. Use Hyperlink function Hyperlink “Server: Every PC should be installed with BO client to build or access the reports. Key file that uses the BO Client. Key file from its local disk drive. Checks the key in the repository.

Followed by repository validation, user can access the BO services. Users log into Webi through Info View. Key is checked for privileges of the logged in user. Then the information is validated and forwards to Repository. If valid, then provides the access to the Universe and underlying database.

SAP BusinessObjects Universe Designer application

Select Tools Detect Loops. Select the suggested context candidate. The Context maps all the joins needed Places the selected joins in a Named Context. Context avoids the conflicts in finding paths. Information is persisted in database as a summary designeg.