Note: This is the continuation from DSO – Step by Step (Part 1 of 2) document. Part 1 dealt with Creation, Extraction and Transformation. This part deals with Loading, Data Activation and DSO Maintenance. (If the images in this document are blurry/not clear, click on the image to open it in high resolution)
4.1 Create a Data Transfer Process(DTP) – DTP controls the movement of data within BW system. It can read data from PSA or a data target, apply the transformation rules and load it to other data targets. Below are the steps to create, configure and execute a DTP.
- In DWW > Modeling > InfoProvider, locate and expand the DSO tree. Right click the Data Transfer Process folder and select Create Data Transfer Process… option
- In the Create Data transfer Process pop-up, Specify the DataSource as source of the DTP and click the OK () button.
- Change Data Transfer Process screen opens up. In the Extraction tab, provide details about the DataSource for the DTP. For Extraction Mode, specify Delta as this ensures that system loads only the requests that are yet to be loaded into data target. Package Size determines the number of records to be extracted in a set.
- In Update tab, specify the error handling settings. Select Update Valid Records, No Reporting (Request Red) option. This ensures that the erroneous records gets written to Error Stack and the only the valid records gets loaded into data target. But the entire set remains unavailable to reporting.
- In the Execute tab, there are options to specify Processing Mode. Select Serial Extraction, Immediate Parallel Processing option and click the Execute button. Data gets processed asynchronously in a background process.
- Click on the Monitor Icon () to open the Monitor: Data Transfer Process page. This will list the status, duration and break down of all the request processing steps.
- With this the data is loaded into the DSO. But the loaded data is stored in the Activation Queue and is not available for reporting.
- In DWW > Modeling > InfoProvider, locate and right click the DSO. Select Manage option from the context menu.
- Manage InfoProvider screen opens up. In the Requests tab, click the Activate button at the bottom of the screen.
- A pop-up windows opens and lists all the requests that are loaded but not yet activated in the DSO. Select the request that needs to be activated and click the Start button at the bottom of the pop-up.
- This will submit a data activation request that will be processed in background. To check the status of activation, go back and see the request row in Requests tab.
- Once the data gets activated, i.e. once the data gets moved from Activation Queue to Active Data table within DSO, the data will be available for reporting and also for loading it into other data targets, usually InfoCubes.
6.1 Deleting Change Log data for Performance Improvement – As the DSO ages, the data in Change Log table piles up creating performance issues. So it is a good practice to free it up periodically. Below are the steps to delete data from Change Log table.
- Go to Manage InfoProvider Screen for the DSO
- In SAP GUI’s menu bar, open Environment Menu and select Delete Change Log Data option
- This opens Delete Change Log Data screen where you can select what data should be deleted based on how old the request is or when it was loaded. Enter the date and click the Start button to delete data before that date.
6.2 Request Automation
- Go to Manage InfoProvider Screen for the DSO
- In SAP GUI’s menu bar, open Environment Menu and select Automatic Request Processing option
- In the pop-up window that opens, you can enable/disable automatic setting status to OK and automatically activating requests. Click on the Save button after making the changes.
6.3 View DSO contents – At times there will be need to view the contents of DSO, be it, the activation queue table, active data table or the change log for administration and re-conciliation purposes. Below steps shows how to view the DSO contents.
- Go to Manage InfoProvider screen for the DSO
- In the Contents tab, there are 3 buttons, one each to view activation queue, active data and change log tables. Click on any of the button to view its content.
- Click New Data button to view the loaded but not yet activated data. This opens the Data Browser screen as shown below. Click on the Number of Entries button to view the record count in the table.
- Click on the Execute button (). Data Browser screen refreshes with the contents of DSO table as shown below.
This concludes the 2 Part document illustrating the steps for Creation, Extraction, Transformation, Loading, Activation and Maintenance of a Standard DSO.
All the steps discussed in Part 1 & 2 of this document can be automated using Process Chains.