SAP HANACreating an Analysis Process

You can use a SAP HANA analysis process to analyze data from certain perspectives, for example to calculate ABC classes or to find scoring information.

Context

With the SAP HANA analysis process, BW users are able to use the functions of the SAP HANA database and can combine these with the functions in the BW system. A SAP HANA analysis process is always made up of exactly one data source, a function for data analysis and a data target. A SAP HANA analysis process can also be used as the source for another SAP HANA analysis process.

The graphic below shows the design time object that is integrated into the BW system process management:

If you are using a SAP HANA database, we recommend using SAP HANA instead of Analysis Process Designer (APD). The process is then performed exclusively in SAP HANA, thus improving performance.

The SAP HANA analysis process does not offer all features of APD however. You therefore need to check whether the functions you need are offered. If not, you can fall back on APD instead.

The main difference in functionality between the SAP HANA analysis process and APD is that only InfoProviders that a column view exists for on the SAP HANA database are supported as data sources.

Example There is no column view for InfoSets, so these cannot be used as data sources. You can create a CompositeProvider on the InfoSet however, and use this CompositeProvider in your SAP HANA analysis process.

Only InfoObjects that have Standard master data access are supported. This is the only type of master data access that there is a colum view for on the SAP HANA database. If you InfoObject has a different type of master data access, you should check whether this is really necessary.

In the SAP HANA analysis process, there are no joins or unions. We recommend doing this using a CompositeProvider. SAP HANA will then be used for processing, and satisfactory performance can be guaranteed.

The data mining methods and models that you can use in APD are not available in the SAP HANA analysis process. We recommend using the native functions in SAP HANA.

You cannot use all InfoProviders directly. By connecting to the DTP however, you can connect all InfoProviders that are supported by the DTP.

1. In the Data Warehousing Workbench under Modeling, choose SAP HANA Analysis Process.
2. In the context menu of your InfoArea, choose Create SAP HANA Analysis Process. Enter a name and description for your analysis process.
3. On the Overview tab page, select a data source.
4. Select the function or procedure for the data analysis.
5. Select the data target.
6. Make any further required settings on the Data Source, Definition of the Procedure, Data Analysis and Data Target tab pages.
7. Activate your analysis process. Once activated, an analysis process can be transported to other BW systems.
   Note Note that the analysis process cannot be transported if the data source is a query as InfoProvider or an analytic index. These objects are only created locally.
8. You have various options for executing the analysis process:
   • By choosing Execute Synchronously, you can execute the analysis process directly and schedule it in the background by choosing Schedule for Background Processing. The result is displayed in the monitor.
   • You can insert the analysis process into a process chain. To do this, go to the editing transaction for your process chain, choose process type  Other BW Processes  Execute SAP HANA Analysis Process .
   • If you have specified in the definition of your analysis process that it can be used in a data transfer process, you can create a transformation for this. To do this, choose  Modeling  SAP HANA Analysis Process  in the Data Warehousing Workbench. Choose Create Transformation in the your analysis process's context menu.