On the Overview tab page, you can make settings for the data source, data analysis and data target.
The following PAL functions are supported:
The advantage of implementing a procedure yourself is that you can reuse it later. You always need to take care of the transport yourself.
You can generate a suggestion implementation that you have to adjust to your requirements. In the proposal implementation, the fields are projected, but not modified.
It is generated in accordance with the assignment information that you define on the source and target. The system generates a name according to the following pattern: 0BW:DAP:<Name of Analysis Process>~PN.. When the analyis process is activated, the procedure in the repository is generated as a repository procedure in the schema defined for this. This does not have a package assignment and can be found via the schema. The advantage of a generated procedure is that it is transported with the SAP HANA analysis process.You should normally use formulas, especially for calculations by field. The system supports this better. If you use procedures, you need to implement a lot of things yourself that are actually already in the system, currency translation for example. You can create formulas directly on the field, in the details for the data source or data target.
You should use procedures if you need complete algorithms that should not be calculated by field and for cases that no formulas exist for.
If you generate an ABAP Managed Database Procedure, the class is generated first of all. This comprised the prefix HAP_ and a generated ID. If the analysis process is changed, the procedure is generated again. You can only insert your own coding in the body. This is not overwritten if the procedure is regenerated. This allows you to enhance the existing method without creating one of your own. If you edit the SAP HANA analysis process from the ABAP Development Tools, you can call the editor directly by double-clicking on the generated procedure. If you edit the SAP HANA analysis process from the BW system, double-clicking on the generated procedure only takes you to the Class Builder. You can display the generated coding here, but cannot edit it.
The result can be saved or, if using the analysis process as the data source for a further analysis process, not saved. If a query is executed on an analytic index, the analysis is executed at runtime if the data is not saved. The control parameters can be entered when executing the query.