--- parser: v2 primary_tag: products>sap-hana\,-express-edition tags: [ tutorial>beginner, products>sap-hana\,-express-edition ] time: 20 slug: hxe-ua-predictive-afm canonical_url: https://developers.sap.com/tutorials/hxe-ua-predictive-afm --- # Predictive Analytics Using Application Function Modeler This tutorial series will cover a pair of sample projects utilizing the predictive analytics capabilities of SAP HANA, express edition. This tutorial will show you how to use a Application Function Modeler to access the predictive analytics library. ## Prerequisites - [Predictive Analytics Using SQL Script] ## Next Steps - Find more Predictive Analysis Library tutorials on the [SAP HANA Academy YouTube Channel](https://www.youtube.com/playlist?list=PLkzo92owKnVw05sPUtcKJM66fYfk9sG-g) ## You will learn - How to use the Predictive Analysis Library through SAP HANA Studio ## Intro This tutorial creates the same models as the previous tutorial by only using template modules within SAP HANA Studio. For more tutorials on using Predictive Analysis Library, see the [SAP HANA Academy YouTube Playlist](https://www.youtube.com/playlist?list=PLkzo92owKnVw05sPUtcKJM66fYfk9sG-g). --- ### Open the SAP HANA Development Perspective In your SAP HANA Studio window, hover over __Window__ -> __Perspective__ -> __Open Perspective__. Select __SAP HANA Development__ if is available, otherwise, click __Other...__. From the drop down list, select __SAP HANA Development__. ![SAP HANA Development Perspective](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/development_perspective_2.png) The *SAP HANA Development* perspective opens. ### Create a New Repository Workspace Through the _Repositories_ tab, right-click on your user login for your tenant database and select __Create Repository Workspace__. ![Create A New Repository](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/create_repository_2.png) The _Create New Repository Workspace_ window opens. Make sure your user login for your tenant database is selected. You may use your default workspace, or untick the _Use Default Workspace_ box and create a new workspace by filling in _Workspace Name_ and _Workspace Root_. By default, these locations are the same as the home repository you select when starting Eclipse and SAP HANA Studio. ![Create A New Repository](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/create_repository_name_2.png) Click __Finish__ to create your new workspace. ### Create a New Repository Package Right-click on your new repository workspace and select __New__ -> __Repository Package__. ![Create Repository Package](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/create_repository_package_2.png) The _Create Repository Package_ window opens. Give your package a name and click __Finish__ to create the package. ![Create Repository Package](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/create_repository_finish_3.png) ### Create a Flowgraph Model Right-click on your new package and select __New__ -> __Other...__. ![New Other](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/new_select_2.png) The _New_ window opens. Scroll down to __SAP HANA__ -> __Database Development__ -> __Flowgraph Model__. Click __Next >__. ![Select Flowgraph Model](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/select_flowgraph_2.png) The _New Flowgraph Model_ window opens. Ensure that your new package is highlighted. Give your flowgraph a name. Ensure that __Flowgraph for Activation as Stored Procedure__ is selected. Click __Finish__. >**Note:** > SAP HANA Studio will automatically add `.hdbflowgraph` to your file name. ![Name Flowgraph](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/name_flowgraph_3.png) Your new flowgraph opens. ### Arrange the Flowgraph Under the _Predictive Analysis Library_ window, select __Time Series Analysis__, scroll down and drag and drop __Auto ARIMA__ onto your flowgraph. ![Auto ARIMA](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/drag_auto_arima_2.png) Under the _General_ window, drag and drop __Data Source__ onto your flowgraph. ![Data Source](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/drag_data_source_2.png) The _Choose a Table or a View_ window opens. For this example, search for and select the _STOCKS (PAL)_ table. Click __OK__. ![Select Stocks](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/loading_stocks_2.png) Hover over the _STOCKS_ block. Click and hold the **Connect** icon ![Connect](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/connect_2.png) from *Data_2* and drag over to _Data_ under the _Auto ARIMA_ block. ![Drag Data to Data_2](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/drag_data_data_2_3.png) Under the _General_ window, drag and drop __Data Sink (Template Table)__ onto your flowgraph. ![Drag Data Sink](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/drag_data_sink_2.png) Hover over the _AUTOARIMA_ block. Click and hold the _Connect_ icon ![Connect](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/connect_2.png) from _RESULT_ and drag over to *DATA_3* under the _TEMPLATESINK_ block. ![Arranged Flowgraph](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/flowgraph_arranged_3.png) ### Adjust Model Properties To view the results you will need to change the _RESULT_ and _TEMPLATESINK_ properties. Hover over _RESULT_ under __AUTOARIMA__. Click the __Properties__ icon ![Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/properties.png). ![RESULT Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/result_properties_3.png) The _Properties_ window opens. Click __Signature__. Change _VALUE_ _Length_ to _5000_. ![RESULT Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/result_properties_5000_2.png) Change the _TEMPLATESINK_ properties. Hover over _TEMPLATESINK_ and click the __Properties__ icon ![Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/properties.png). ![TEMPLATESINK Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/templatesink_properties_3.png) Under the _Properties_ window, add your user schema to _Authoring Schema_. Add a name for _Catalog Object_. You may also check the _Truncate Table_ box. ![TEMPLATESINK Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/templatesink_properties_additions_2.png) ### Create the Model Change the properties of the flowgraph. Right-click on the white space and select __Properties__. ![Flowgraph Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/flowgraph_properties_3.png) By _Target Schema_, add your user schema. ![Flowgraph Target Schema](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/flowgraph_properties_schema_3.png) Click the __Activate__ icon ![Activate](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/activate.png). A new job will appear in your Job Log. Click the __Execute__ icon ![Execute](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/execute.png). > __Note:__ > If you receive an error during this step, see the troubleshooting section below. ### Preview the Model Return to the _SAP HANA Administration Console_ perspective. Under your user login to your tenant database, cascade down from __Catalog__ -> __User__ -> __Tables__. Right-click on **`Catalog_Object`** and click __Open Data Preview__. > __Note:__ > The Catalog Object is named earlier in this tutorial. ![Catalog Object Preview](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/catalog_object_preview_3.png) You may notice that this data is identical to _Step 2: Run the Model SQL Script_ in the previous tutorial. ### Prepare the Model for Analysis Return to your flowgraph. Under the _Predictive Analysis Library_ window, select __Time Series Analysis__ and scroll down and drag and drop __ARIMA (Forecast)__ onto your flowgraph. ![Drag ARIMA (Forecast)](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/drag_arima_forecast_2.png) Hover over the _AUTOARIMA_ block. Click and hold the _Connect_ icon ![Connect](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/connect_2.png) from _RESULT_ and drag over to _INPUT_ under the _ARIMAFORECAST_ block. Change the *PARAMS_2* by hovering over it and clicking the __Properties__ icon ![Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/properties.png). Under the _Fixed Content_ tab, change the _INTARGS_ to __200__. ![Change PARAMS_2](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/params_2_intargs_2.png) ### Prepare the New Flowgraph Blocks Under the _General_ window, drag and drop another __Data Sink (Template Table)__ onto your flowgraph. Hover over the _ARIMAFORECAST_ block. Click and hold the _Connect_ icon ![Connect](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/connect_2.png) from _OUTPUT_ and drag over to *DATA_4* under the new *TEMPLATESINK_2* block. As before, change the _TEMPLATESINK_ properties. Hover over *TEMPLATESINK_2* and click the __Properties__ icon ![Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/properties.png). Under the _Properties_ window, add your user schema to _Authoring Schema_. Add a name to _Catalog Object_. You may also check the _Truncate Table_ box. ![Edit TemplateSink_2 Properties](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/templatesink_2_properties_2.png) Click the __Activate__ icon ![Activate](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/activate.png). A new job will appear in your Job Log. ### Preview the Data Click the __Execute__ icon ![Execute](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/execute.png). Go to the _Systems_ tab. Refresh your tenant database. Find the results table under your user login. Go to __Catalog__ -> **User** -> **Tables** -> **`Second_Catalog_Object`**. Right-click on the table and select __Open Data Preview__. ![Catalog Object 2 Preview](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/catalog_object_2_preview_2.png) You will notice that this data is identical to _Step 4: Run the Predict SQL Script_ in the previous tutorial. ### Unsupported encoding Cp 1252 When you _Activate_ your Auto ARIMA model, you may encounter this error: ![Unsupported Encoding Error](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/encoding_error.png) To fix this error, open the _Problems_ window. Go to __Window__ -> __Show View__ -> __Other...__. From there, go to __General__ and select __Problems__. Click __OK__. ![Problems](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/problems.png) You will see the error in the log. Right-click the error and click __Quick Fix__. The _Quick Fix_ window opens. ![Quick Fix Window](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/quick_fix_window_2.png) Click __Finish__. A message explaining the fix will appear. ![Quick Fix Message](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/quick_fix_message.png) Click __OK__. Click the __Activate__ icon ![Activate](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-predictive-afm/activate.png) and continue with the tutorial. #### Additional Information - Find more Predictive Analysis Library tutorials on the [SAP HANA Academy YouTube Channel](https://www.youtube.com/playlist?list=PLkzo92owKnVw05sPUtcKJM66fYfk9sG-g)