If you do not regularly delete data from the PSA, the PSA tables can grow to an unlimited size. Large tables increase the costs of data retention, the downtime for maintenance tasks and the performance of the loading process. This function allows you to delete requests from the PSA. This reduces the volume of data in the PSA.
Examples of applications are deleting incorrect requests or deleting delta requests that have been updated successfully in an InfoProvider and that no further deltas should be loaded for. You can create selection patterns in the process variant Deleting Requests from the PSA and thus delete requests flexibly.
Including the deletion of requests from the PSA in process chains
You are in the plan view of the process chain where you want to insert the process variant.
Character string ABC* results in the selection of all DataSources that start with ABC, and end with any other characters. The character string ABC+ results in the selection of all DataSources that start with ABCfollowed by any other single character.
For example, you define a selection pattern for the DataSources ABC*. To exclude certain DataSources for this selection pattern, create a second selection pattern for the DataSources ABCD* and set the indicator Exclude Selection Pattern. This selects all DataSources that start with ABC, with the exception of those that start with ABCD.
You can select the following status indicators:
Delete Successfully Updated Requests Only
Delete Incorrect Requests that were not Updated
With Copy Request Selections you can copy the settings for the age and status of a selection pattern (request selections) to any number of selection patterns. Select the selection pattern to which you want to copy the settings, place the cursor on the selection pattern from which you want to copy, and choose Copy Request Selections.
The plan view of the process chain appears. The process variant for deleting requests from the PSA is included in your process chain.
Deleting requests for a DataSource in the Data Warehousing Workbench from the PSA
You are in an object tree in the Data Warehousing Workbench.
The system deletes the requests from the PSA table.
You can also delete requests in DataSource maintenance. Choose Goto → Manage PSA (pushbutton ). Follow the instructions above, starting from step 2.
If you delete requests from the PSA, they remain physically in a partitioned PSA table for the time being.
The requests are first deleted logically (from table RSTSODSREQUEST) and are given a deletion flag in PSA partitioning administration (table RSTSODSPART). You can no longer access these requests.
The requests are not deleted physically from the PSA table until all requests in a partition have been logically deleted and have thus been given the deletion flag in PSA partitioning administration.
The change log is stored as a PSA table. For information about deleting requests from the change log, seeDeleting from the Change Log.