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

Transformations

Examples and Explanation:

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.

After Create you get the following screen

Give The APD a Meaningful Description.

Save the APD Before Going to RSA1 Transaction 

Need a Target DSO to Store the Data

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

You get the following screen:-

DSO Edit Screen

Edit the ‘Type of Direct Update’ in the Settings

Add key fields and Data fields to  DSO

Save and Activate

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

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.

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.

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

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’

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.

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

Activate and Execute

Result as per Filter Criteria

   

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