Skip to Content

Export as stored procedure from SAP PA to HANA

Hi Guys,

Can someone guide me where I can proceed if I want to export the model from SAP PA expert analytics to do <export as stored procedure>?

Currently, SAP PA working offline no database conected. What I want to test is how the model/algorithms exported from the SAP PA expert analytics works in SAP HANA PAL.

I have searched some document, but not yet get appropriate one.

Appreciate this.

Regards,

Emma

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 06, 2016 at 08:58 AM

    Hi Emma,

    you can export as HANA Stored procedure only if connected to SAP HANA. Other options are .SPAR or .PMML.

    To export the model:

    - go to the Predict Room

    - select the model in the Designer View

    - select Export Model underneath the Components Pane in the Component Actions section on the
    lower right side of the screen

    - select the export option

    You can also check in the user guide (section 16) for more details:

    http://help.sap.com/businessobject/product_guides/pa25/en/pa25_expert_user_en.pdf

    Regards,

    Clarissa

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Emma,

      yes that's one way of doing it. If you want to export your model as a HANA Stored procedure and run it on HANA you typically would have your data in HANA already.

      To build the model you'd use a representative sample of the data.

      Regards,

      Clarissa

  • Apr 21, 2016 at 09:57 AM

    Hi Emma,

    Is your question answered now?

    Thanks & regards

    Antoine

    Add comment
    10|10000 characters needed characters exceeded