The Analysis Process Designer 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 was consolidated in the Data Warehouse and that exists in InfoProviders.
The data can be merged from a number of sources, changed step-by-step using different transformation methods, and displayed in new views. The results of the analysis are then stored, for example in an InfoProvider or in a CRM system. It is then available for all decision and application processes. The Analysis Process Designer is used especially in closed-loop scenarios.
The transformation methods offer, for example, basic operations such as filter, join, or formulas, as well as advanced methods for data mining. The data mining methods support you when you explore and identify meaningful relationships in your data.
More information: Data Mining
Examples of analysis processes include calculating ABC classes and determining frequency distributions or scoring information.
You can use queries, database tables, and files as well as InfoProviders as data sources in the analysis process to help you perform ad hoc analyses. You can also store the results of the analysis directly in a file. Note the data quality of the sources you use, since they normally will not have been included in the ETL process of the Data Warehouse.
Analysis processes can be created on a graphical user interface using drag and drop. Data from different data sources in the BI system can be combined, transformed, and prepared for analysis in a number of individual steps. This allows it to be saved again in data targets in the BI system (DataStore objects for direct update or InfoObjects with attributes) or in a CRM system. For this purpose, various
● Data sources,
● Transformations and
are available to you.
Various additional functions support you in modeling and executing an analysis process, as well as in interpreting the analysis results. More information: Checking Data
The following figure shows the various steps in the Analysis Process Designer:
First select a data target that contains the required data. This data is then prepared and transformed. The transformed data is saved in a BI object or in another system. For analysis, you can display the data in a query in the Business Explorer.
More information: Modeling an Analysis Process
There is a separate process type for executing analysis processes.
Analysis processes are integrated into the versioning concept (active, inactive version, content version, and content delivery).
Analysis processes are connected to the BI transport system as TLOGO objects. More information: Transporting BI Objects.