Skip to Content

Summary

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.

Introduction

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

    

Data
Sources                            Transformations                                               Data
Targets

DS.pngTR.pngDT.png

Creating an Analysis Process Designer (APD)

P1.png

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.

P2.png

After selecting Query as data source, there you find two tabs

  1. Source
  2. Extended Settings

Under first tab, you need to give the source Query name details.

/wp-content/uploads/2014/03/z_421672.png

After data source as Query, select the filter depends upon the requirement. Here also you find 2 tabs.

  1. Field Selection
  2. 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.

/wp-content/uploads/2014/03/z_421672.png

/wp-content/uploads/2014/03/z_421672.png

/wp-content/uploads/2014/03/z_421672.png

The available options for aggregation level are:

/wp-content/uploads/2014/03/z_421672.png

  • 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
  • Plant

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.

/wp-content/uploads/2014/03/z_421672.png

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.

/wp-content/uploads/2014/03/z_421672.png

/wp-content/uploads/2014/03/z_421672.png

So the assignment looks like:

/wp-content/uploads/2014/03/z_421672.png

/wp-content/uploads/2014/03/z_421672.png

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.

/wp-content/uploads/2014/03/z_421672.png

In the data target, you have 2 tabs

  1. Data target – give the Direct update DSO details

/wp-content/uploads/2014/03/z_421672.png

    2. Target Area – here we need to give the key fields and the functionality of the content update.

/wp-content/uploads/2014/03/z_421672.png

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-

/wp-content/uploads/2014/03/z_421672.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply