Deleting Requests from the PSA 

Use

With this function you delete requests from the PSA. This reduces the volume of data in the PSA. It is a good idea to delete incorrect requests or deltas for a data target, to which you do not want to load any more delta.

Functions

For a particular DataSource, you can specify day X or a date, to delete the requests, which were loaded before this time. You can display a list of all the requests in the chosen PSA table to check this.

Since the change log is also stored as a PSA table, you can also use this function to delete change log records. You can find additional information under Deleting from the Change Log.

Activities

  1. Choose the PSA tree in the Administrator Workbench under Modeling.
  2. Use the context menu for an application component, InfoSource, or a PSA Table and choose Delete PSA Data. Choose Delete on a request level.

    3. In the following screen, the DataSources for the previously chosen application component, InfoSource, PSA table, or for the request are displayed.

  3. Use a simple mouse click in the DataSource overview to select the DataSource for which requests need to be deleted.

    4. To help you do this, you can display a list of the requests.

  4. Specify the number of days or a date, that you want to use as a cutoff point. All requests before this are deleted. You also have the option to specify whether you only want to delete successfully updated requests, and/or only incorrect requests, that are no longer updated in a data target (this is only valid for transaction data).
  5. Specify the postprocessing, if necessary.

    6. In BW 3.0, automatic process control has been enhanced and improved significantly with the concept of process chains. Controlling the process by using postprocessing events is no longer enhanced, but continues to be supported. We recommend that you only use process chains for schedules of connected processes that must be re-defined.

  6. Schedule the delete job.

Including the deletion of requests from the PSA in the process chain

If you want to automate the deletion of requests from the PSA, you can include an appropriate process variant in a process chain.

  1. In the maintenance of process variants, you specify the DataSource for which the requests need to be deleted by using the implicit selection of a PSA table or an InfoPackage.
  2. Specify the requests that need to be deleted by determining the days or dates. You also have the option to specify whether you only want to delete successfully updated requests, and/or only incorrect requests, that are no longer updated in a data target (this is only valid for transaction data).
  3. Save your entries and go back.
  4. In the following screen, confirm the addition of the process variants in the process chain.

You arrive in the plan view for the process chain. The process variant for deleting requests from the PSA is included in your process chain.