Skip to Content

Create view off HANA TABLE? EDM or CDS


been asked to create a EDM? (hdbdd file) table in HANA (not sure of the terminology) so it can be exposed to 3rd party tool like power bi.

I have a bog standard SQL table MYTABLE1

I have been told to create an "EDM' table a TABLE2. as below..and then copy the data from TABLE1 into TABLE2 ie...create table 2 as below.. Then copy the data,.using sql - which i can do.

namespace ZXX1.ZXX_IL.ZXX_TDEXT.ZTABLE;          
@Schema: 'XX_RBM'                                        
context YY {                                             
    @Catalog.tableType : #COLUMN                             
    Enity MYTABLE2 {                            
    CLIENT_NO                                : Int64;        
   } ;  

This is fine but , my question

a) is there an easy way to generate this EDM in HANA studio as I have 50 SQL tables , i have to create these EDM tables and then copy the data from the bog standard sql table to this in this new EDM table.

b) rather than the above syntax , is there an alternative can you use as CREATE TABLE or VIEW as select to achieve the same thing, I have seen this syntax below ..may not be relevant

I don't have access to ABAP or GUI transactions only Hana studio..where do you run this if at all?


c) why do i have to do this ? why can't I expose the HANA SQL table to power bi directly without the EDM? etc.. Why do I need the EDM version of the table?

Sorry if this dosen't make sense I don;t know the terminology..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 27, 2017 at 01:45 AM

    Here is blog post that tell you how to generate ...

    Try this

    Add comment
    10|10000 characters needed characters exceeded