Configuring Remodeling Rules

Context

You can make a number of settings that affect the execution of remodeling rules. The settings always apply exactly for the remodeling rule that they are created for. The most important setting you make here is which tool the remodeling rule is executed with: with a variant optimized for SAP HANA, with the data transfer process (DTP) or using the ABAP/4 database utility (SE14).

Procedure

You are in Administration Remodeling in the Data Warehousing Workbench.
Choose Remodeling Rule Configuration. The configuration screen for the remodeling rule appears. The following options are selected by default:
- Debugging is deactivated
- Processing optimized for SAP HANA is selected if you are using a SAP HANA database. The option for setting creating a data backup is also selected.
- Processing via the DTP is selected if you are not using a SAP HANA database.
- Reactivation of transformations is activated.
- Deletion of backups is activated.

Debugging:

You can make debugging settings here. This allows you to debug the entire execution, the background execution if using the database utility (SE14), the execution of the simulation or resetting of a step in the monitor. In the entry fields, you can define how long the system should wait (in seconds) until the current execution starts.

HANA Settings:

This area is only visible if you are using a SAP HANA database. If you set the HANA-Specific Implementation flag, the remodeling rule is executed with an implementation optimized for SAP HANA. This is the fastest execution method.
You can also make the following settings here:
- Create a backup of the table: This setting is recommended so that remodeling can be reset or restarted if errors occur.
  Note
  Using the backup function slows down the process of remodeling a provider. Some remodeling rules, such as deleting a characteristic from an InfoCube or adding a characteristic with a constant as the initial value do not require any temporary data. The backup function can be deactivated here in order to improve performance. It is not possible to reset if errors occur however.
- The package size can be specified per data set or number of data records. We recommend specifying the package size per data set. If this option is selected, the optimum number of simultaneously remodeled rows is calculated on the basis of the table width and the data set specified.

DTP Settings:

If you set the Use DTP flag, the InfoProvider is remodeled using the DTP technology and with temporary objects. You can also specify the package size and the number of background processes to be taken over as the setting for the DTP that is created. Note that the number entered here is always increased by one, since the remodeling process needs a free background process itself.

Settings for the ABAP/4 database utility (SE14):

If you set the Use SE14 flag, the InfoProvider is remodeled using the ABAP/4 database utility.

Miscellaneous:

Under Miscellaneous, you can make a number of general settings:
- You can define a prefix for all temporary objects that are created during remodeling. The standard prefix is Z.
  Note If a temporary object already exists with the name that the newly created temporary objects would have, the remodeling process cannot be started, and you have to delete the object before you can continue. If you do not want this, you can simply change the prefix. The temporary objects are then given a different name.
- You can stipulate that the transformations are reactivated.
- You can stipulate that backups are deleted after remodeling.
- You can stipulate that the remodeling process pauses after a certain step. You can restart the process in the monitor.
Choose Save. Your settings will be implemented when the remodeling rule is executed.