What is Analysis Process Designer ?- Step by Step Process to Extract Data to a File and Rearranging the Columns Using Transformations

Introduction:

The Analysis Process Designer (APD) is a workbench with an intuitive graphical user interface for creating,executing, and monitoring analysis processes. The analysis process is primarily based on data that wasconsolidated in the Data Warehouse and that exists in InfoProviders.

Analysis processes (APD) can be created on a graphical user interface using drag and drop. Data fromdifferent 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 (DataStore objects for directupdate or InfoObjects with attributes) or in CRM system

Step  by Step Process to Extract Data to  a File and Rearranging the  Columns Using Transformations




Scenario 1: Analysis Process Designer 





Scenario 1I: Analysis Process Designer