SAP® BW: A Step-by-Step Guide

Chapter 7. InfoCube Design

InfoCube design not only determines business functionality, but also directly affects system performance.

In this chapter we will first look into the star schema implemented in BW. Next, we will analyze three InfoCube design alternatives for the same business scenario described in Chapter 1. Finally, we will briefly discuss two other InfoCube design techniques:

• Compound attributes

• Line item dimensions

Note

In BW, use of aggregates is a key technique for improving query performance. Therefore, when evaluating an InfoCube design, we must consider whether the design supports aggregates as critical criteria. See Chapter 8 for more information on aggregates.

BW Star Schema

In Chapter 1, we introduced the concept of a star schema. ...