How to Guide Step by Step on Analysis Process Designer (APD)
This article explains about the Analysis Process Designer which is useful for optimizing thereport execution time with the various options. Whenever User experiences the more time for execution of the Report then it is more worthful and improves the
performance of the execution of the report.
The Analysis Process Designer is the application environment for the SAP data mining solution. The Analysis Process Designer (APD) makes it possible to find and identify the hidden or complex relationships between data in a simple way. The
APD workbench provides an intuitive graphical interface that enables you to visualize, transform, and deploy data from your business warehouse. Various data transformations are provided for this purpose, such as statistical and
mathematical calculations, and data cleansing or structuring processes.
An APD generally consists of three parts:
- Data Sources: Read data from Info Providers, Attributes of a Characteristic, Query, Flat Files, Database Tables
- Transformations:Filter restricted amount of data, Aggregate Data, Join data from different Data Sources, ABAP Routines, Formula,
Sort data, etc.
- Data Targets: Write data directly to Data Store Objects (DSOs), Flat files, Update CRM Attributes, Change attributes of a Characteristics, etc
Sources Transformations Data
Creating an Analysis Process Designer (APD)
The APD can be accessed from DW Workbench (RSA1) -> Edit tab -> Analysis Process Designer, or alternatively through Tcode: RSANWB.
Right click on any existing Application to create a new Analysis Process designer.
Enter a description for the New APD.
Created report on Inventory – Stock Analysis, which has taken much time than expected to execute the report .To optimize the execution time, we have used option called APD which improved the execution time significantly.
Step by Step
Here Query is Data source for our target Report. The char and key figures are taken from the data source Query and design the target report with specific filters and aggregation.
After selecting Query as data source, there you find two tabs
- Extended Settings
Under first tab, you need to give the source Query name details.
After data source as Query, select the filter depends upon the requirement. Here also you find 2 tabs.
- Field Selection
- Filter Conditions
Plant is selected as Field selection and Filter so that data will be lesser due to filter condition and executes faster.
In this example Plant is given as A001.
The available options for aggregation level are:
- SUM Summation
- MIN Minimum
- MAX Maximum
- CNT Number of Aggregated Records
- CN0 Number of Aggregated Records (Only Values Not Equal to Zero)
- AVG Average
- AV0 Average (Only Values Not Equal to Zero)
- NOP No Aggregation (X, If More Than One Value Uneq. to 0 Occurs)
Under Aggregation, fields to be used in the form of groups and the fields for which the values are to be aggregated
Under Grouping Fields-
- Local Currency
Under Aggregation Fields-
The required key figure values in the report and select the Aggregation level depends upon the requirement.
In this case aggregation is SUM for all key figure values.
After aggregation step, we need to map the source fields to target info objects.
Click the ‘Same Info Object’ to automatically assign the corresponding fields.
So the assignment looks like:
Creating Data Targets
For the target Info objects, first of all a Direct Update DSO is to be created .Select the required char and key figures. APD supports Direct Update DSO.
The processed data will now be pushed into the Direct Update DSO that we had created. Select the DSO icon from the Data Targets to write data directly into the Data Store Object.
In the data target, you have 2 tabs
- Data target – give the Direct update DSO details
2. Target Area – here we need to give the key fields and the functionality of the content update.
Save the analysis process by clicking icon Save.
You will be prompted to enter the technical name for the same. Provide as per the naming convention.
Once you have checked the Analysis process using Check Button, activate it by Clicking Activate Button.
The Analysis process is ready for use. Click on to execute the process.
The complete APD design flow looks like below-