O'Reilly logo

SAP® BW: A Step-by-Step Guide by P.E. Henry Fu, Ph.D. Biao Fu

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

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:

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

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