Introducing the Universe
Working with a Local Project
Accessing Data Sources with a Connection
Designing a Data Foundation
Designing a Business Layer
Testing Objects
Publishing a Universe and Building a Query with SAP Applications

Building a Data Foundation

Objective

After completing this lesson, you will be able to explain the purpose and function of the data foundation layer that connects databases in SAP BusinessObjects Information Design Tool.

Data Foundation

Watch the video to understand the critical role of the data foundation in translating your raw database into a structured, report-ready model.

Create a Data Foundation

To begin, select the project folder in the Local projects view.

Next, go to the File menu and select New→Data foundation. The Data foundation wizard will guide you through the necessary steps simply follow the prompts provided.

Once you have completed the wizard, click Finish. As a result, the data foundation will be created as a .dfx file within your local project.

The user selects Data Foundation from the New menu and enters Motors as the resource name in the New Data Foundation dialog.

Note

A multi-dimensional universe, also named OLAP universe does not contain a data foundation. For more information about this topic, please read Building an OLAP Business Layer

Let's Summarize What You've Learned

  • The data foundation connects your physical database to the business layer without duplicating tables.
  • It supports a single connection and uses database-specific SQL syntax for advanced features.
  • The data foundation editor lets you add tables, joins, and other key elements.
Learning

SAP FacebookSAP YoutubeSAP LinkedIn