O'Reilly logo

Creating Universes with SAP BusinessObjects by Taha M. Mahmoud

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Northwind data model

Now that we downloaded the Northwind Microsoft Access database and successfully created our ODBC connection, let's have a look on the Northwind data model. We can see two main contexts in the Northwind database, as shown in the following screenshot:

The Northwind data model

The first context is related to orders, and the other one is related to inventory. We can think of context as a subject area that covers some related information stored in some related tables. Before we go deep into the Northwind data model, let's first define some terminologies that we will use.

Dimensional modeling terminologies

We have three types of information from the business ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required