Resolving Loops in a Universe

Define what a Loop is Detect and recognize loops in Universe Using Aliases and Contexts to resolve the loops Identify when in the design process you resolve loops Be able to use shortcut joins and know when to use them as alternative for resolving loops. Be able to resolve recursive table structure loops. … A loop exists when the joins between...

Read more »

Introduction to Semantic Layers

Introduction to Semantic Layers The semantic layer is a metadata layer that abstracts the complexities of the data source. The end user sees only a logical grouping of available, well-named fields for use and does not have to concern them with the details of database design or need any SQL knowledge. In Business Objects XI, two semantic layers are supported business views and universes. With the merging of Crystal Decisions and...

Read more »

Can a Universe connect to multiple databases?

No. Universe will connect to only one database.How do you define universe parameters?The first step in creating a universe is to specify its parameters. These parameters include the definition of a universe, which is comprised of: the universe name, a description of the universe, a connection to an RDBMS. You enter universe parameters from the Universe Parameters dialog box. This dialog box also lets you set up database options,...

Read more »

What is a universe?

Universe provides a semantic layer between you and the database. It consists of classes and objects named in business terms. It is basically a mapping of table and the columns in the database to classes and objects respectively in the query panel.Alternatively, It is logical mapping of data in business terms.In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform...

Read more »

What is a macro?

A macro is a series of commands and functions that are stored in a Visual Basic for Applications module and can be run whenever you need to perform the task. If you perform a task repeatedly, you can automate the task with a macro. You create macros using the Visual Basic Edit...

Read more »