How to generate and import HA300 EPM_MODEL in Hana

[Former Member]

To the point:

Log in Sap, Generate sample data for SWND* tables using transaction SEPM_DG, Import tables and data in Hana.

No need to read more.

Long story

As meny of You know, There is no tables from HA300 examples in fresh Hana installation. You can import SHINE model though.

I recommend using SHINE even for HA300 examples. It will take some time going thru examples, but that time will be well spent on thinking in "Modelling mode".

Any table from HA300 example has its similliar table that can be used instead. There's no NODE_KEY, PARENT KEY fields, but thats not as important.

If You must use HA300 data model, here are the steps

1. Log in Sap, check out tables of interest,  SWND* in SE16n or SE11.  They are empty probably. (for instance table SNWD_BPA_CONTACT)

2.  Use SEPM_DG transaction in SAP to generate sample data.

Check out: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0a7f673-59da-2f10-6e8b-bc7fe5dd4...

3. Re-check table in SE16n.

4. Use Data Provisioning method You prefer to load tables and data to Hana.

You can use Sap Data Services, Sap LT Replication server would be an overkill :smile:

IMPORT flat file

IMPORT flat file scenario is simple and you don't need extra tools.

For each table you want to import into Hana:

1. Download to file system:

Se16n, Download table to xls (Change header name if necessary)

2. Sap Hana Studio File->Import  ->SapHana Content Folder  "Data from Local file"

(  Change data types if necessary )

QED.

Alternative to download table:

You can download table to file system with FM 'SAP_CONVERT_TO_XLS_FORMAT', or write ABAP program (you can tweak something I used for csv download to write Your own code )

Hope it helps,

    Dubravko Katulic.