Show TOC

Creating a DTP for a Semantically Partitioned ObjectLocate this document in the navigation structure

Context

The data transfer process is not part of the semantically partitioned object but the wizard still helps you to create the data transfer processes.

Templates make it easier to create several DTPs of the same type. A DTP template contains default parameters that can be used to create DTPs for the partitions. You can create DTP templates so that you can quickly and easily create a large number of DTPs with the same default settings.

The Create dialog box for DTPs only displays the parameters that are actually needed for semantically partitioned objects. There is also a status overview that allows you to quickly identify inconsistencies.

The maintenance screen is divided into three areas: DTP generation, DTP templates and the detailed view.

Area: DTP Generation

The DTP Generation area displays all objects belonging to the semantically partitioned object. Here you can add or delete DTPs from templates using drag and drop. To make processing easier, you can filter for each source or each partition. Various statuses are displayed.

DTP status:

After a DTP has been generated, the status is green. It remains green so long as the DTP remains unchanged. If the DTP is changed, the status also changes.

DTP filter:

Here you can see what type of filter is being used: an automatically created and generated filter or a user-defined filter. To display the properties of a filter that has been generated, click on the Generated symbol . To edit the properties of a user-defined filter, click on the User-Defined symbol.

DTP template:

The status of the relationship between the assigned DTP and the DTP template is displayed here. If the template is changed after the assignment or if the assigned DTP is changed, the status is displayed as not equal to.

Area: DTP Templates

A standard template is provided. You cannot change the template. You can make changes to the settings after assigning the template as a DTP however. You can also create your own templates. You can store these templates in folders to have a clearer overview.

A template that is still being used in the form of DTPs cannot be deleted.

Area: Detailed View

The details of a previously selected DTP or the details of a template are displayed in the detailed view. In the case of a DTP, the details of the DTP and the details of the underlying template are displayed. This detailed view is also a status display. Any deviations from the template are shown in red, and everything identical to the template is shown in green.

Procedure

  1. In the wizard, choose Create Data Transfer Process.
  2. If you want to use your own template: Create a folder in DTP Templates.
  3. Create a template in this folder. Choose Template Create New DTP Template
  4. Enter a description for the template and choose Next.
  5. In Extraction, you can select the extraction mode, package size and key date for master data. You can switch on the currency conversion.
    Note

    You can only select extraction mode Delta in the case of semantically partitioned objects that are based on InfoCubes.

    In addition, you can specify the tables from which the data is extracted. For extraction from the DataStore object, you have the following options:

    • Active Table (with Archive):

      The data is read from the active table and from the archive or from a near-line storage if one exists. You can choose this option even if there is no active data archiving process yet for the DataStore object.

    • Active Table (without Archive):

      The data is only read from the active table. If there is data in the archive or in a near-line storage at the time of extraction, this data is not extracted.

    • Archive (Only Full Extraction):

      The data is only read from the archive or from a near-line storage. Data is not extracted from the active table.

    • Change Log:

      The data is read from the DataStore object's change log.

    For extraction from the InfoCube, you have the following options:

    • InfoCube Tables:

      Data is only extracted from the database (E table and F table and aggregates).

    • Archive (Only Full Extraction):

      Only data that is archived or is in a near-line storage is read.

  6. In the Update area, you can perform settings for error handling. The following settings are possible:

    • Switched off:

      If an error occurs, the error is reported as a package error in the DTP monitor. The error is not assigned to the data record. The system does not build the cross-reference table to determine the data record number. Processing is quicker. The incorrect records are not written to the error stack since the request is terminated and has to be updated again in its entirety.

    • No update, no reporting (default):

      If errors occur, the system terminates the update of the entire data package. The request is not released for reporting and analysis. The incorrect record is highlighted so that the error can be assigned to the data record. The incorrect records are not written to the error stack since the request is terminated and has to be updated again in its entirety.

    • Update valid records, no reporting (request red):

      This option enables you to update valid data that is released for reporting and analysis only after the administrator has checked the incorrect, not updated records, and has manually released the request. The incorrect records are written to a separate error stack in which the records are edited and can be updated manually using an error DTP.

    • Update valid records, reporting possible:

      The valid records are available immediately for reporting and analysis purposes. Automatic follow-on activities are performed automatically (such as modifying aggregates). The incorrect records are written to a separate error stack in which the records are edited and can be updated manually using an error DTP.

  7. Under Execute, you can enter information about the request status:

    • Technical Request Status:

      This parameter specifies the behavior of a request generated by the current data transfer process, if the system logged warnings when processing the request. The technical request status can be set to green or red.

    • Overall Status of Request:

      This parameter determines the behavior of a request generated by the current data transfer process, if the technical part of processing is finished and the overall status is to be set. The following settings are allowed for the parameter:

      • Set Overall Status Automatically:

        If this setting is selected, the overall status is automatically set to the same status as the technical status, if the request is completed with the technical status green or red.

      • Set Overall Status Manually:

        If this setting is selected, the overall status of the request initially remains unchanged, if the technical part of processing was completed with status red or green. In particular, this means that data for a green request is not released for reporting or further processing. The overall status has to be set manually by the user or by a process in a process chain.

  8. Under DTP Filter, you can choose between Create Automatically or User-Defined:

    • If you select Create Automatically, the system generates a filter, based on the partition properties, when the DTPs are generated. The filter ensures that only data relevant for the partition is loaded.

    • If you select User-Defined, no filter is created. In this case, you have to make sure that the data is filtered in the source or in the transformation. You should expect longer loading times here. In some cases, the system might select User-Defined automatically if the filter cannot be generated.

  9. Choose Save DTP Template.
  10. Select the partitions that you want to assign the DTP to and drag the template onto the partitions.
  11. Choose Generate Start DTP Generation. The DTP is now generated from the template.