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:


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

Get SAP® BW: A Step-by-Step Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.