+++> 9.Analysis Process Designer (APD)

Analysis Process Designer:

                        It is a Workbench with user interface where we can do analysis process. This analysis process is based on the data present in the data warehouse which exists in info providers. Data from various sources in the BW system is combined, transformed and prepare for analysis where we can again resave into the targets like Direct update ODS, or Info-objects with attributes.

 

“RSANWB” is the T-code for APD

 

It reads data form info object master data attributes , Info provider , query , flat file , and form data base table.


Transformations(options) to Modify the data:
Filter, Aggregation, Join , Union , Projection , Sort , Formula , List to data record, Data record to list ,ABAP  Routine , and Data mining specific tools

Writes data to the following targets including data mining
Writes to Master data, DSO , Flat file , CRM system  and data mining models  


Creation of APD:

Scenario:
The requirement is to evaluate the report based on Closing Stock, this closing stock is non cumulative key figure and is not physically stored in the cube. So to achieve this we use direct update DSO, using this we created an APD where the source is the query and target is the DSO. From the query we are stamping the closing stock into that DSO and we load data into other data target like cube etc.., based on our requirement and make analysis.
This kind of scenarios we go for APD’s.
Step 1: Right click on an application to create a model

 

Step 2: Enter the model properties and drag  the desired source into the work area.


 

Make the detailed settings in the dialogue box that appears:

 

Step 3: Move a target to work area
 
Step 4 : Link those to nodes
 

Step 5: To make a field assignment right click on the flow arrow which is linking those nodes.
                     

Step 6: Activate   and Execute  the APD

 

Step 7: The data is posted and a log appears:

 

Step 8: Double click on the data target and choose “display data” to display the data.

 
 
Result:
Data in the DSO :
 


                                                       *************************