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