Create view off HANA TABLE? EDM or CDS

[former_member212650]

Hi

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?

namespace ZXX1.ZXX_IL.ZXX_TDEXT.ZTABLE;
VIEW TABLE2 AS SELECT FROM "SCHEMA".TABLE1
{
                     
    CLIENT_NO                                   
                        
};

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..

[former_member212650]

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

Try this