Technology Blogs by Members

Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!

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

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

Source
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
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.

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.