Direct update DSOs are generally used in conjunction with the APDs (Analysis Process Designer).
APDs are very helpful in analyzing the hidden patterns in the data coming from various sources.
E.g. APO system creates plan data using complex algorithms for certain actual sales data in BW. Both of these can be fed to the APD to analyze the differences in Actual and plan values and find out the useful metrics like Forecast Bias, Forecast Accuracy etc.
APD writes this data to a direct update DSO which can be directly used to generate reports in BEx Query Designer. These reports can then again be fed to APD to do more analyses on the data.
Tcodes: RSDODS, RSANWB
E.g. Data transfer from BEx query to direct update DSO using APD.
Note: We can only integrate an APD process into a process chain using the process type ‘ABAP Program’.
To do this, choose the ABAP report ‘RSAN_PROCESS_EXECUTE‘
Step 1: Make sure there is a cube or dso with data, create a BEx query on the data and save it.
Step 2: Create a direct update DSO and activate it.
Step 3: Go to the tcode RSANWB and create an APD in the ‘General’ Application folder. Give a description and technical name.
Step 4: Use some transformations like ‘Filter’ and connect your source query to the target Direct update DSO.
Step 5: In the target area, select ‘overwrite complete content of the DSO’
Step 6: Double click on the transformation symbol and select the ‘Fields Assignment’ tab. Select ‘Automatic Assignment’ and select ‘Save InfoObject’
This will execute the APD in the dialog mode and write the records to the direct update DSO.
You can also select to run the APD in the background by selecting the ‘Schedule Job’ icon and maintaining the desired date and time.