Skip to Content

What is APD and step by step process of implementation

Analysis Process Designer (APD)for BI:

  • The Analysis Process Designer (APD) is a workbench with a visual interface for creating, executing, and monitoring analysis processes.
  • The analysis process is primarily based on data that was consolidated in the Data Warehouse and that exists in Info Providers.
  • Analysis processes (APD) can be created on a graphical user. Data from different data sources in the BI system can be combined,

        transformed, and prepared for analysis in several individual steps. This allows it to be resaved in data targets in the BI system

  • Interactive modeling (drag & drop) workbench for analysis processes
  • Analysis of data at every step of the Analysis process

 

The same data, yet different

Gain new insights into your data:

Explore the data, re-aggregate, join, sort, filter, transpose and store

Img-1.jpg

Transformations

Examples and Explanation:

Img-2.jpg

Img-3.jpg

Img-4.jpg

To implement an APD, first use the RSANWB transaction to reach the following screen.

Steps For Implementing APD

The left panel of the screen displays all the components that can be used to build an analysis process, and the right panel displays the design area where the analysis process is built. Here we will use the ‘General’ Analysis Process. Right Click on ‘General’ and select ‘Create’ as shown below.

Img-5.jpg

After Create you get the following screen

Img-5A.jpg

Give The APD a Meaningful Description.

Img-7.jpg

Img-8.jpg

Save the APD Before Going to RSA1 Transaction 

Img-9.jpg

Need a Target DSO to Store the Data

Creating the Required Direct-Update DSO using T-Code:- RSA1

Img-10.jpg

You get the following screen:-

Img-11.jpg

DSO Edit Screen

Edit the ‘Type of Direct Update’ in the Settings

Img-12.jpg

Add key fields and Data fields to  DSO

Save and Activate

Img-13.jpg

Selecting  Data Target (Come Back to APD screen…)

Here, we will be using the Direct-Update DSO that we created earlier to act as a Data Target.

To do this, Drag and drop the DSO icon to the Design pane

Img-14.jpg

Selecting  Transformation

Different analysis functions used on the data are grouped under Transformations. These different transformations range form simple filter functions to more complex data mining functions (as shown below).

In our example, we will be using a filter in between the source and the output.

To do this, drag and drop the filter Icon into the design pane as shown below.

Img-15.jpg

Connection

Now, to apply the filter, we need to supply it with the query output.

Drag and drop the connection from the query output to the filter input as shown below.

Blue dotted lines indicate that the connection is still incomplete.

Img-16.jpg

The solid black line (as shown below) indicates that the connection is complete.

Filter – Field  selection

Now, double click on the Filter, to apply the filter conditions

Img-17.jpg

Here, you need to specify the fields on which you wish to apply a filter on. Here we will be applying a filter on plane type and Airline

Filter –  Conditions

Move to the ‘Filter Condition’ tab and Select the ‘complex selections’

Img-18.jpg

 

Here, you need to specify the fields on which you wish to apply a filter on. Here we will be applying a filter on plane type and Airline

We can automatically map fields which have been created on the same info-object.

Img-19.jpg

Click on the automatic assignment button shown below and select ‘Same Info Object’ as shown below.

Img-20.jpg

Activate and Execute

Img-21.jpg

Result as per Filter Criteria

   Img-22.jpg

We find that The APD implementation has been completed successfully and the result can be verified.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply