Start with Analysis Process Designer

[Former Member]

Scenario: Send the output of a query to a table

Solution:

We have n number of ways to send the output of a query to a table. I would like to demonstrate the use of APD to achieve this scenario.

Step 1: Identify the Query and the fields to be send
The Fields selected is:
1: 0CALDAY
2: 0COMP_CODE
3: 0QUANTITY



Step 2: Create a Transactional ODS with the Fields in the Query
Key Fields:
0CALDAY
0COMP_CODE
Data Fields:
0QUANTITY



Step 3: Go to Analysis Process Designer (Tcode -- RSANWB)

Step 4: Create.  Select Generic Application from the list



Step 5: Drag the Query object from the Data Sources to the design area.  Double click and assign the query which has to be used.



Step 6: Drag the Filter object from the Transformations to the design area

Step 7: Drag the ODS object from Data Targets.  Double click and assign the Transactional ODS created to store the Query Output.



Step 8: link the objects. Select the query object and draw an arrow line towards the filter object. From the filter object draw a second arrow line towards the target ODS.



Step 9: Double click on the second line drawn from filter towards the ODS. This will open a window which shows the field assignment options

Step 10: Click on each field methods and select the respective fields from the query. Do this for all the fields in the mapping assignments.





Step 11: Save the Application. Give the technical name for the Application.

Step 12: Activate. Now the APD is ready to execute. Right click on the APD created under the generic group and select Execute.



Step 13: Verify the ODS for Data.

Reference: help.sap.com Analysis Process Designer