Advanced design techniques of Data Foundation

In this section, we will talk about some features that will help us later in this chapter to solve SQL design traps. The main idea of the design techniques presented here is to control the SQL queries generated from our Universe. We will learn how to control the number of returned queries based on the selected objects.

Alias tables

An alias table, as discussed in Chapter 4, Creating the Data Foundation Layer, is a named copy of another database entity (table/view). We already learned how to create an alias table, and here we will learn how to use it to fix SQL design traps.

Context

Context is a join path definition between Data Foundation entities. The SQL engine will create and submit a separate query ...

Get Creating Universes with SAP BusinessObjects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.