Purpose of document:
How to guide demonstrates the technical installation steps for AFL library in SAP HANA database version 1.0.0.82
Background:
For one of our requirement customer wanted to find the hidden trend of demand and supply for particular dealer against for particular material. As well as they want to forecast the trend of orders based on historical data.
Business Objective:
To increase business process efficiency by using SAP HANA in-memory technology
Technical Environment:
Existing SAP HANA hosted in AWS having version SAP HANA 1.0.82 (SPS08) and installation of SAP AFL version 82 revision. SAP HANA developer has created views based on business requirement and consumed it into SAP PAL. We have implemented single exponential smoothing algorithm in SAP PAL.
Prerequisites:
To use the PAL functions, you must:
Checking PAL Installation To confirm that the PAL functions were installed successfully,
check the following three public views:
● sys.afl_areas
● sys.afl_packages
● sys.afl_functions
These views are granted to the PUBLIC role and can be accessed by anyone
PFB Installation step by step. Happy Reading!
1.Checking current SAP HANA Version on AWS
a) HANA version check from Command Line:
->Login to OS level as user "SIDadm"
->Run the command "HDB version"
b) HANA version check from HANA Studio:
->Login to Studio and check the "Version History" as below
->HANA Studio -> HANA system -> Right Click -> properties -> Version History.
Output: 1.00.82.00.394270 (Which means we are on SAP HANA 1.0, Version 82)
2. Downloading required corresponding patch level for AFL
3. Transfer downloaded media on to JUMP off rdp(server)
4. Copy Downloaded files from JUMP off server to HDB to /hana/shared/HDB/HDB00 using FileZilla as below.
(Note: Drag & drop selecting location from Jump off to HDB (Remote Site))
Installation Phase
Files Uncarred as above.
chmod –R 777 SAP_HANA_AFL as shown below
Installation Done!!!
Add AFL Roles to user profile for required users to use & verify afl schema in place.
We faced issues wherein we didn’t find the AFL Area views.
Analysis: AFL Lib version installed is of version 85.
Resolution : AFL Lib version should match the SAP HANA DB version which is 82.
Thanks
Ajitav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |