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.


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 O’Reilly online learning.

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