Analysis Process Designer 

Use

In SAP BW, data from various databases from systems available in the company are collected, consolidated, managed and prepared for evaluation purposes. There is often further, valuable potential in this data.

It deals with completely new information that is displayed in the form of meaningful connectivity between data but that is too well hidden or complex to be discovered by simple observation or intuition.

The Analysis Process Designer (APD) makes it possible to find and identify these hidden or complex relationships between data in a simple way. Various data transformations are provided for this purpose, such as statistical and mathematical calculations, and data cleansing or structuring processes.

The analysis results are saved in BW data targets or in a CRM system. They are available for all decision and application processes and thus can be decisive (strategically, tactically, operatively).

Examples of analysis processes include the calculation of ABC classes, determination of frequency distribution or of scoring information.

Integration

The analysis process designer is the application environment for the SAP data mining solution. The following data mining functions are integrated into the APD:

·        Creating and changing data mining models

·        Training data mining models with various BW data (data mining model as data target in the analysis process)

·        Execution of data mining methods such as prediction with decision tree, with cluster model and integration of data mining models from third parties (data mining model as a transformation in the analysis process)

·        Visualization of data mining models

You can find additional information under Data Mining.

The APD is integrated into the Administrator Workbench:

 

Restrictions

Integration into the Administrator Workbench has the following restrictions:

·        The node texts are not language dependent.

·        You can only integrate an analysis process into a process chain using the process type ABAP program. To do this choose the ABAP report RSAN_PROCESS_EXECUTE.

·        Analysis processes are not displayed in the data flow display.

·        The where-used list only functions from the analysis process to other objects and from data mining models to the analysis process, but not from other objects such as InfoProviders.

Functions

The analysis process designer is a workbench with an intuitive, graphic user interface for the creation, execution and monitoring of analysis processes.  Analysis process can be created using Drag&Drop. Data from different data sources in the BW system can be combined, transformed and prepared for analysis in several individual steps so that it can then be resaved into targets in the BW system (transactional ODS object or InfoObjects with attributes) or in a CRM system. Various

·        Data sources,

·        Transformations and

·        Data Targets

are available.

Various additional functions support you during modeling and executing an analysis process, as well as during interpretation of the analysis results. See also Checking Data.

The following graphic shows the various steps in the Analysis Process Designer.

First select a data target that contains the desired data. Then this data is prepared and then transformed. This transformed data is then saved in a BW object or in another system. For analysis, you can display the data in a query in the Business Explorer.

For more information, see Modeling an Analysis Process.

Versioning

Analysis processes are integrated into the versioning concept (active, inactive version, content version and delivery).

Transport Connection

Analysis processes are connected to the transport system for the SAP BW as TLOGO objects. You can find additional information under Transport Systems.