HANA course HA300 EPM Model is not suitable to SHINE

[Former Member]

Dear Community,

I'm studying for my certification and I'm using the HA300 course material. The exercises relates to a model with the name “EPM_MODEL”.

I surfed a while on scn to found out that the EPM_MODEL is served with the SHINE demo content.

I imported the delivery unit successfully to my HANA SP8 installation. While observing the new tables in Catalog --> SAP_HANA_DEMO I noticed that the schema is different to the course material.

Let me explain:

In the course material I do need tables like:

• EPM_MODEL.SNWD_PD,
• SNWD_PO,
• EPM_MODEL.SNWD_PO_I,
• EPM_MODEL.SNWD_ORG_UNITS,
• EPM_MODEL.SNWD_PAYROLL
• and so on

The SHINE schema offers the following tables:

Unfortunately the structures and semantics of the tables are completely different so that I can’t use this tables.

Does anybody know where I can get the “original” EPM_MODEL with demo data?

Best regards,

Sebastian

[Former Member · Accepted solution]

Hi Sebastian,

seems like we shared same problem. I'm preparing for cert for some time now too.

If You must use EPM_MODEL then you can try and generate some data in Sap system and then load to Hana.

1.First check out SWND*  tables that you need (in SE11 or SE16n). Empty I guess.

2.Generate data with transaction SEPM_DG

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

Some tables will be filled, for example SNWD_BPA_CONTACT , some not, others use sunscreen 

There is a way to fill them all I guess. Some data You can fill on your own if you need. Its just a few tables and you need few records per any of them.

3. You then use one of Data Prov Tools Hana universe gave us....IMPORT is good enough (import flat file scenario)..simple and you dont need extra tools.

For each table:

-Go to SE16n, download data to xls (Change header names if necessary) - or write Abap code to do that.

-Import xls to Hana - Sap Hana Studio: File->Import  ->SapHana Content  Folder  "Data from Local file" )

Change data types if necessary..just go on.

This way, model for all tables will be loaded (tables created), data for ones that you filled with data. ANd there's your EPM_MODEL 

But my advice would be - dont bother. SHINE model is perfect for simple examples even from HA300.

Any table from HA300 examples has its similar table in SHINE that can be used instead...there's no NODE_KEY, PARENT KEY in Shine tables..but those fields are only burden in those examples).

Sometimes You will have to omit some fields (take another one instead), sometimes you'll have to JOIN with third table to get text or something, but it will only deepen your understanding of data modelling in HANA.

For me exercises then become true, and not just "going thru the motions" just to finish them 

I wish you luck in certification and have fun preparing. I am enjoying myself, hope you are too.

I Hana.

Hope this helps.

Take care,

Dubravko.

[Former Member · Accepted solution]

Hi Dubravko,

Great! That's absolutely the correct answer! Thanks!

I've found the tables in BW and generated with SEPM_DG the sample data.

To load the date into my HANA I’ve used a "Replication Job" provided by SAP BO Data Services Workbench.

Except three tables (wired RFC error) I was able to load all tables into HANA with only one job.

Thanks for your support,

Sebastian

[Former Member · Accepted solution]

you right Dubravko.