Analysis Process Designer (APD)

Posted by on




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:

• Transformations:


• Data Targets:



let us assume the following as example:

Data Sources

Attributes of characteristic Customer (Master Data) and a Data Store Object (DSO) containing Sales data.



Transformation

The inbuilt function Aggregate Data is used to aggregate the Sales Amount, and Join function is used to join the data fetched from Customer characteristic and Sales data DSO. The Filter function restricts the values according to Country (for this example).



Data Targets

A Direct Update DSO is used to store the resultant data.



Online Reporting

An InfoCube will receive data from the Direct Update DSO.



Tcode :RSANWB


















Choose the required Characteristics and Key Figures from the available list on the left hand side, in the ‘Field Selection’ tab.






The next step is to transform the data according to our need. Select the ‘Aggregate’ function to summarize the Sales data according to Sales Amount.
Join the Source Sales Data DSO to the Aggregate function.








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)




Next we need to join data from the two Data Sources. Drag and drop the ‘Join’ function into the Work area.










For this example, let us filter the resultant data on the basis of Country. Select ‘Filter’ function from the Function selection area, Drag & drop into our work area.











In the next tab ‘Filter Conditions’, put the values for restricting the amount of data.





The processed data will now be pushed into the Direct Update DSO that we had created.














So the final flow looks like below. Next right-click on the connecting link and select ‘Properties’.






Save the analysis process

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  activate it

The Analysis process is ready for use. Click on  execute





Online Reporting

 An Info Cube can be created to get data from the Direct Update DSO populated by the APD process. Reporting can be done on this Info Cube.



Looking for SAP job? - Archon Solutions

Comments

  1. faryal naazDecember 16, 2015 at 7:49 AM

    This is really tremendous that the way you describe I'll really appreciated your work.hope i'll come back to get some more information .Thanks
    CCNA Routing and Switching

    ReplyDelete
  2. UnknownJune 28, 2016 at 11:41 PM

    thank's for sharing usefull information.we are providing ONLINE COURESE in USA

    ReplyDelete
  3. UnknownAugust 12, 2016 at 11:41 PM

    Good information about complex relationship between the data. is this APD use for Coding people.Online SAP BO Training Classes

    ReplyDelete
  4. UnknownAugust 15, 2016 at 1:07 AM

    Your article is very informative, thanks for posting it...
    SAP FICO Online Training | SAP MM Online Training

    ReplyDelete
  5. UnknownJune 1, 2017 at 4:23 AM

    Why images are broken on your blog now ?

    ReplyDelete
  6. gracylaylaAugust 7, 2017 at 10:56 PM

    Hi,
    Thank you for this post very clear explanation with nice infographics and Images. Keep it up... SAP BW.

    ReplyDelete
  7. UnknownAugust 30, 2017 at 5:27 AM

    Excellent post, some great resources. Styling your blog the right way is key. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about and I am eager to learn more about this topic.

    SAP FICO Training in Chennai

    SAP MM Training in Chennai

    ReplyDelete
  8. logistic-solutionsJanuary 3, 2018 at 3:59 AM


    Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    sap mbe reseller

    ReplyDelete
  9. ankita dhruvMarch 5, 2018 at 3:11 AM

    Hi, I have a doubt.We have a query with more than 50 characteristics, there is a limitation in MDX backend that we cannot use more than 50 Char, while we are duplicating the query and connecting with Union, we get error of duplicate key(as Material is key in direct update DSO). Any way we can use union in this case?

    ReplyDelete

Post a Comment