Find Used BW Objects
This workflow populates an External Data Source named BW Usage. This External Data Source is used by the BW Change Impact Analysis workflow. The Find Used BW Objects workflow finds BW Query objects (object type ELEM) using data in the SAP table RSZCOMPDIR. Only active REP-type ELEM objects are included in the results.
Note that the External Data Source is overwritten each time this workflow is run. Used BW objects found by other means should be appended to the External Data Source prior to running the BW Impact Analysis workflow.
The BW Usage External Data Source has the following columns:
| Column | Description |
|---|---|
| TYPE | The type of a used BW Object. |
| NAME | The name of the used BW object. |
| COUNT | The usage count for the object (arbitrarily set to 1). |
Creating RFC Destinations
Before you begin, you will need to create an RFC Destination for the SAP system from which to extract used BW Objects.
Preparing the Workflow
To prepare the Find Used BW Objects workflow, drag its workflow template from the Templates folder into your own workspace, then modify the workflow as follows:
To specify the system from which to extract used BW objects:
-
Select the System 3 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.
-
Select the RFC Destination for the system to analyze, then click ‘Save’.
Save the workflow using the ‘Save’ toolbar button.
Running the Workflow
To run the Find Used BW Objects workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running action is marked with an animated display. When the workflow execution has completed, the BW Usage External Data Source will be populated.