Need of ODS in APO-BW

[Former Member]

Hi,

We have all the information in BW in cubes and we are planning to extract to APO-BW and load to APO. Do I need to use any ODS in my landscape? I know the functionality of ODS but what purpose could an ODS serve in a general APO-BW landscape?

Thank you.

[Former Member · Accepted solution]

Hi Raj,

This entirely depends on your needs. An ODS is useful if you need to consolidate data from different sources. It also useful if you need to perform a lookup during the data load (e.g. lookup values that can be found in the ODS while loading to a cube). Depending on your requirements, you might also need to transfer delta values instead of the final values. An ODS can help here as well (although you need to spend extra time to activate the data in ODS). This might be helpful if the ODS feeds it's data to multiple cubes (where always doing a full load to the cubes might not be efficient).

Hope this helps.