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 :
*************************