In this,we demonstrated ODS as a new technique that allows us to build a multilayer structure for detail reporting at different levels. In particular,we completed the path in Figure indicated by solid lines.
Along the way,we discovered some differences between ODS objects and InfoCubes:

  • ODS objects are not based on the star schema and should not be used for multidimensional analysis. For the same reason,ODS objects do not aggregate data as InfoCubes do,cannot have aggregates,and cannot be included in a multi-cube.
  • The default update type for an ODS object is Overwrite,and the default update type for an InfoCube is Addition.
  • Data must be loaded into ODS objects via PSA. InfoCubes do not have this restriction. ODS objects use 0RECORDMODE values to implement the delta update.

Key Terms
Key Terms

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics