HANA PAL SQL Architecture

Step by Step Guide for PAL Algorithms.

Method 1 – High-level Pictorial representation – Direct Method recommended

 

Method 2 – High-Level Pictorial representation – Wrapper Method

 

Step 1

  

Step 2 –

 

Method 3 – Flowgraph

The First two method is to complete SQL way where we create an input table, result table and call SQL wrapper or procedure directly. We have many SAP documents with SQL samples for this. Below I am showing Flowgraph method for running ABC Analysis algorithm.

Input and Result tables are already created as per Algorithm requirements.

                          
 – Karthik Addula