Use Semantic Groups in DTPs for Flexible Splitting of Data into Separate Packages

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • March 19, 2012
Avoid inconsistent or unexpected results in data loads by ensuring that data that needs to be grouped stays together in data packages during loading.
Key Concept
You can use the semantic key to aid in grouping data during loading to ensure like data is processed and loaded in the same data package.

When loading data into an InfoProvider, an SAP system groups the data into packages in order to load the data into the source. The size and grouping of the packages are dictated by the system at the time of extraction. The extractor uses the packet size and source data structure to assemble the data into coherent loading packets in order to group the source data. The extraction is executed in individual packages rather than in one large full data package because large data volumes can overwhelm system resources if the system tries to extract large data volumes as one unit.

In most data loads, the contents and grouping of the data into packages is not relevant. The system chooses the first package, loads this package, then the next. The contents of the packages are based on the contents of the source data. The system is careful to cut off the data when the package size limit is reached. In order to see the package size, double click on the data transfer process (DTP) and go to the Extraction tab.

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.