Beginner
// Explore More Tutorials
Predictive Analytics Using SQL Scripts
11/26/2018
10 min.
This tutorial series will cover two approaches to a sample project utilizing the predictive analytics capabilities of SAP HANA, express edition. This tutorial will show you how to use SQL scripts with the predictive analytics library.
You will learn
- How to use predictive analytics with a pre-written SQL script
This tutorial describes one of many SAP HANA Academy Predictive Analysis Library tutorials. For more tutorials on using Predictive Analysis Library, see the SAP HANA Academy YouTube Playlist.
Step 1: Memory Cleanup (VM only)
Step 2: Copy the First SAP HANA Academy Script
Go to the SAP HANA Academy GitHub site. Click on the PAL repository. From there, navigate to Code Snippets -> PAL 110 Time Series - Auto ARIMA Model.sql.
Click on Raw.
Use the keys Ctrl + a to select all, and Ctrl + c to copy the script.
Step 3: Run the Model SQL Script
Open an SQL command line to your tenant database through your new user. Paste the script and click the Execute icon 
to run the code. The Result page appears.
Note:
This script assumes the user name is DEVUSER. If you created a user with a different name, you will need to modify the script by replacing the instances of DEVUSER with your user’s name.
Note:
The first time you run this script, you may receive the errors Could not execute ‘DROP TYPE …’ and the error Could not execute ‘DROP TABLE “#PARAMS”’. This is expected behavior as these elements are created in the script. The errors will not affect output.
This builds the model used for predictive analysis.
Step 4: Copy the Second SAP HANA Academy Script
Go back to the SAP HANA Academy GitHub site. Click on the PAL repository. From there, navigate to Code Snippets -> PAL 111 Time Series - Auto ARIMA Predict.sql.
Click on Raw.
Use the keys Ctrl + a to select all, and Ctrl + c to copy the code.
Step 5: Run the Predict SQL Script
Back in your command line, paste the script and click the Execute icon to run the code. A new Result page appears. This creates a predictive analysis table from the model you created earlier.
Note:
This script assumes the user name is DEVUSER. If you created a user with a different name, you will need to modify the script by replacing the instances of DEVUSER with your user’s name.
Step 6: View the Results
To preview the data, go to your user login to your tenant database and cascade down to Catalog -> USER -> Views. Right-click on V_Results and click Open Data Preview.
From there, you can view the raw data or create charts under the Analysis tab.
Step 7: Script Information