Building the Data Foundation layer

The Data Foundation layer is the core resource for any Universe. Here, we will start managing our Data Foundation objects (tables, views, alias tables, and derived tables) as well as the relationship between them using joins. Data Foundation can refer to one or more data connection. You can also build as many Business layers as you wish on top of the same Data Foundation layer. We will talk in detail about each object, but let's talk first about the types of Data Foundation.

Types of Data Foundation

When we create a new Data Foundation, it will ask if we want to use a single-source or multisource Data Foundation. It is a major choice to decide and select the right type from the beginning, because in the current SAP BO 4.x, it is not possible to change it later on. There is no conversion routine that can be used to convert a single-source Data Foundation into multisource and vice versa. So, we need to know when we have to select and use single source and when...