-
-
Theta join
A join that links tables based on a relationship other than equality between two columns.
-
-
-
-
Strategy
Scripts that automatically extract structural information about tables, columns, joins, or cardinalities from a database. Designer provides default strategies but a designer can also create strategies. These are referred to as external strategies.
-
List of values
A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. In Designer you create a list of values by running a query from the Query Panel. You can then view, edit, purge, refresh and even export this file. A list of values is stored as an .lov file in a subfolder of the UserDocs folder.
-
Loop
A situation that occurs when more than one path exists from one table to another in the universe.
-
Join
A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
-
Structure pane
The graphical component within the main Designer window that shows the schema of the universe. It reflects the underlying database structure of the universe.
-
Workgroup mode
A work mode whereby a designer creates universes in an environment without a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.
-
User object
An object created by the end user from the BusinessObjects User module. A user object can be inserted into a universe by the designer.
-
Universe domain
The area of the repository that holds exported universes. The universe domain makes it possible to store, distribute, and administrate universes. There may be multiple universe domains in a repository.
-
Subclass
A component within a class that groups objects. A subclass can itself contain other subclasses or objects.
-
Shared connection
A shared connection is used to access common resources such as universes or documents. It can be used by several users. Information about a shared connection is stored in a SDAC.LSI or SDAC.SSI file; its definition is updated dynamically.
-
Secured connection
A secured connection is used to access universes or documents that may be restricted or confidential. It can be shared by several authorized users. Stored in the repository, the definition of a secured connection is updated dynamically.
-
Quick Design
A wizard in the Designer module that provides guided instructions for creating a basic universe. It lets a designer name a universe, set up a connection to a database, select strategies, create classes and objects, as well as generate joins with cardinalities.
-
Query
In Designer a query is a technique for creating or modifying a list of values associated with an object. From the Query Panel, a designer builds a query from the classes, objects, and conditions of a universe. In the BusinessObjects User module, a query is a type of data provider. An end user builds a query from a universe, and then runs the query to generate a BusinessObjects report.
-
Personal connection
A personal connection is used to access resources such as universes or documents. It can be used only by the user who created it. Information about a personal connection is stored in both the PDAC.LSI and PDAC.SSI files; its definition is static and cannot be modified.
-
Offline mode
The work mode in which the designer works with universes stored locally.
BO Designer Interview Questions
Ans