Show TOC

Settings for Uploading Retail Panel Data Locate this document in the navigation structure

 

To upload retail panel data, you must make the following settings:

  • Create a data delivery agreement

  • Define a process for market research data

  • Create BW process chains for DataSources of retail panel data, and then create process steps that use these process chains

  • Define data sets for incoming self-descriptive exchange (SDX) format files and associate them with process steps and the DataSources that are used for extraction

  • Define a file set that contains one file only – the metafile – and do not assign a process step to this file set

  • Set up a directory with folders for each data delivery agreement

  • Define the time aggregation level

  • Define field mapping between the fields in incoming files and the fields of the extract structures

  • Run the report Map Fields for Market Research Data (/DDF/ADU_MAP_CUST_SDX) to identify the names of the fields in the (SDX) files and to map between those fields to fields in the extract structures

    This mapping is stored in the mapping tables

  • Adjust the predefined mapping manually, if necessary

  • Define hierarchy levels

  • Define time derivation

  • Activate the data delivery agreement

  • Ensure that the folder scanner is running in the system or scheduled as a periodic job in the background