Hi Ganesh, Thanks for sharing your knowledge. I have one doubt, please correct me if I am wrong. In 'Fact category' we should not combine Master and Tx data, but in 3rd view at "time 14.32" you have joined EKKO and EKPO table. It is combination of Master and TX data. how is it possible in Fact type?
Hi Ganesh, I've a doubt in composite or consumption view. I've written the logic like this @AbapCatalog.sqlViewName: 'ZSQL_COMP_TEST' @VDM.viewType: #COMPOSITE @Analytics.dataCategory: #DIMENSION define view zcds_composite_test as select from kna1 { key kunnr, name1, ort01 } But you told like Composite / Consumption view should not interact with DB directly right... Can you plz confirm it..
Hi, one doubt in this. like is it really mandatory to use the @VDM.Viewtype:#CONSUMPTION annotation. what's the purpose of using this annotations. can't we directly create these 3 types of CDS without these annotations?
Actually yes. In simple words, those annotations helps to visible the CDS in the different source systems. Ex, I believe if your CDS to be visible in SLT/Analysis of office level then the consumption annotations only helps. If you design a CDS which is not consumed by those then these are not required.
Hi Ganesh, First of all I would like to thank you for providing these wonderful videos. These are pure gems. I am an ABAPer and learning ABAP on HANA. Your videos are immensely helpful. Now, coming to the point. I am getting confused here. As per my understanding while using association we have to link a common datasource to all other association data source. In simple words, I have 4 data source A,B,C & D. Now I can make association between A + B , A + C , A + D. But cant make any association like B + C or C + D. Thats what I understood from your CDS association video ( Video no 7, 12:20 minute). But here you are creating association between _mat.matnr and _matxt. Then how is it possible ? Am I missing something here ? Please let me know.And sorry for such a long text.
@@just2shareji Hi Ganesh, Thanks for your reply. I think , I am getting it now. Find my understanding below. Correct me if I am wrong. Here, you are making association between _mat.MATNR = _matxt.MATERIAL. We are allowed to do that because field MATNR is available in source i.e. _po . If it was not present in _po , then it wouldn't be possible to create this association. I think that is what you said as thumb rule in video no 7. But I deduced it in wrong manner .