New PBS CPOS solution for Big Data in the Retail Industry

For its CPOS solution, PBS has chosen an astonishingly simple approach for a fast analysis and a heavily compressed and compliant storage of POS data. The non-SAP data is archived in an audit-proof manner in its original format in Fixed Content Storage. The portion of the data that should be used for validation of the complete set of data or for general analyses is copied directly into the PBS Nearline database. It is not necessary to save the data content in SAP. Data access is performed via transactions, reports and/or queries via the PBS Nearline Interface. All advantages of the analysis server are used for aggregation, summation, and filtering. A link to the stored original file is kept.

Data Mapping

The structure definition of the transfer objects is performed using the workbench as well as the mapping between the import structures of the original files and the target structures of the analytic server. The linkage is rule-based. For example, fields can be linked to one another via direct assignment, via a native SQL function, but also via an ABAP function. With its integrated versioning concept the solution will accommodate the future development of the data structures.

Automated Data Transfer

POS data is created almost continuously in enterprises with a global network of subsidiaries. This makes a cyclical transfer of the data necessary in order to use it for timely daily evaluations and ad-hoc decisions. For this, PBS CPOS comprises a scalable transfer component that transfers the data in a rolling process into the target structures.

Integrated Top-Down Access

Data access is performed based on queries in the SAP system. The data can be seamlessly displayed from the aggregated data view right through to the original POS transaction via drill-down. Data access is enhanced by a program API that enables a customer-specific linkage to the SAP standard processes.

Summary

  • Using PBS CPOS you can integrate external data into the SAP Information Lifecycle Management.
  • A high-performance transfer process ensures fast copying and efficient preparation of the original data.
  • Original files are transferred to audit-proof storage, information that is relevant for analytical evaluations and validation processes is transferred into the PBS Nearline storage.
  • Linkages are guaranteed between the data from the PBS Nearline storage and the original data from the storage system.
  • Extremely fast data accesses and analyses are possible using ad-hoc queries. A program API is available for customer-specific purposes.