This was probably already addressed by another blog post but I couldn’t find it unfortunately, so if you find it’s a duplicate, I’ll withdraw mine.

One of my colleague at SAP asked me this question and I kind of found out that the answer was not so obvious if you haven’t played with the new “Auto” algorithm feature for long.

Also I think this could apply to any HANA online scenarios.

So, usually when you use the “Expert Analytic” (former Predictive Analysis), with text files, you were able to add your initial data set, create an “Auto-Classification”, save the model and then add a new data set and finally apply the saved model.

But when working with HANA online, “Expert Analytic” allows you to only work with one data set. In other words, you cannot add a new data set in the “Prepare” room.

So how do I apply a model I build with my training data on a new data set?

The answer is not far from what the “Automated Analytic” module is doing when using it in a production environment. You will first need to export the model, then apply it to your new dataset.

Next question is how do I export my model?

But let’s start from the beginning, after launching the Expert Analytic, create a new “Document” and select “Connect to SAP HANA One”

/wp-content/uploads/2015/04/image002_693301.png

Next is to enter your HANA connection details then hit “Connect”:

/wp-content/uploads/2015/04/image003_693323.png

Then, select your dataset

/wp-content/uploads/2015/04/image005_693324.png

The dataset will be analyzed, and the column names and type will be retrieved.


/wp-content/uploads/2015/04/image007_693325.png

Now you can select the “Predict” room, add your “HANA Auto-Classification” algorithm, configure it, then you can run it ,

/wp-content/uploads/2015/04/image009_693326.png

Once the run phase is completed, you can then right-click on the “HANA Auto-Classification” node and use the “Save as Model” item.


/wp-content/uploads/2015/04/image010_693327.png

Once saved, the model will appear on the right side bar under “Models”. Select the saved model, then click on “Export Model”

/wp-content/uploads/2015/04/image011_693328.png

From the following popup, use the “.spar” file format.

/wp-content/uploads/2015/04/image012_693329.png

Save it on your desktop for example.

/wp-content/uploads/2015/04/image013_693330.png

Now, your model has been exported, so we now have to create a new “Document” and select “Connect to SAP HANA One”, select your the dataset to be scored. Then, on the right side bar, you can click on the “+” sign, and use the “Import Model” item.

/wp-content/uploads/2015/04/image014_693331.png

Select the “spar” file previously created

/wp-content/uploads/2015/04/image015_693332.png

Select the model to import from the list

/wp-content/uploads/2015/04/image016_693333.png

You will now be able to use it in the “Predict” room to score your new dataset.

/wp-content/uploads/2015/04/image017_693334.png

Hope this save you some time.

This article was built using SAP Predictive Analytics 2.1 using a HANA instance where the Automated Predictive Analytics (APL) was previously setup.

Any comments, feedback or opinions are very welcome!

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply