/ Browse / Learning Journeys / Creating SAP BusinessObjects Universes using the Information Design Tool / Data Foundations

Basic SAP BusinessObjects Universe Design

Describing Universes
6 mins
Working with Local Projects
17 mins
Quiz

Data Connections

Data Foundations

Business Layers

Universe Deployment

Loops in a Data Foundation

Data Restrictions

Lists of Values (LOV)

Parameters

Navigation Paths

SQL Traps

Object @ Functions

Universe Management with Data Foundation and Business Layer Views

Universe Security

Linked Universes

Tell us what you think

We want to create the best possible experience for our learners. Your feedback helps us to improve the experience for everyone.

Give feedback

Knowledge quiz

It’s time to put what you’ve learned to the test, get 7 questions right to pass this unit.

An equi-join is a join that is based on column values between two tables.

Choose the correct answer.

True

False

Under what situations would you use derived tables?

There are three correct answers.

To create a table that contains a selection of columns from different tables

To create a single table that combines two or more tables

To create a table that contains no columns and rows

To create a table with columns from other tables

What does a theta join do?

Choose the correct answer.

Demonstrate ranges

Demonstrate parallels

Demonstrate report filters

Demonstrate table inconsistencies

What is the purpose of a join on the data foundation?

Choose the correct answer.

To identify primary and foreign keys.

To act as a restriction.

To define cardinality.

What is the term for the result of a query that was run on two related tables that are not joined?

Choose the correct answer.

Caesarean

Cardinality

Cartesian

Multiple filter names may be applied to each column.

Choose the correct answer.

True

False

On which table do you usually define an outer join?

Choose the correct answer.

Table 1

The table containing all the data

Table 2

What does the Data Foundation browsing pane of the Data Foundation Editor show?

Choose the correct answer.

Business Layer architecture

List of users

Tree view of the tables and joins

Schema architecture

Learning