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

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 ...

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