Chapter 9. Operational Data Store (ODS)

In Section 7.5, we discussed line item dimensions as a technique for detail reporting. In this chapter, we will demonstrate another technique, Operational Data Store (ODS). It allows us to build a multilayer structure for detail reporting at different levels, including the line item level.

Specifically, ODS is a BW architectural component located between PSA and InfoCube (Figure 9.1). The ODS layer itself can contain multiple ODS objects with data at different levels of detail.

ODS IN BW

Figure 9.1. ODS IN BW

As shown in Figure 9.1, there are many ways to send data to their destinations. If one destination is an ODS object, ...

Get SAP® BW: A Step-by-Step Guide 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.