2022 Dec 05 6:22 PM
Hi Team,
Looking for some simple input to help align my understanding of VDM with what is provided by SAP.
In listing SAP CDS Views with annotation ANALYTICS.DATATYPE: #CUBE I am seeing 3 different VDM View Types
I see #CONSUMPTION / #COMPOSITE / #BASIC
Question No. 1
Is the purpose of #CUBE solely to create a Transient InfoProvider regardless of the VDM.VIEWTYPE and thus can be reported on by any analytic tool?
Question No. 2
When should a ANALYTICS.DATACATAGORY: #CUBE be a VDM.VIEWTYPE of #COMPOSITE vs #CONSUMPTION?
I think the combinations of VDM.VIEWTYPE and ANALYTICS.DATATYPE is being not so well defined in the documentation to provide enough context.
Thanks for any input on this higher level topic!
I used the following really useful SQL Snippet for my analysis:
SELECT HEAD1.STRUCOBJN AS ViewName,
HEAD1.NAME AS Annotation,
HEAD1.VALUE AS Value,
HEAD2.NAME AS VDMType,
HEAD2.VALUE AS VDMTypeValue,
HEAD3.NAME AS DataCategory,
HEAD3.VALUE AS DataCategoryType
FROM "SAPHANADB".DDHEADANNO AS HEAD1
LEFT JOIN "SAPHANADB".DDHEADANNO AS HEAD2
ON HEAD1.STRUCOBJN = HEAD2.STRUCOBJN AND HEAD2.NAME = 'VDM.VIEWTYPE'
LEFT JOIN "SAPHANADB".DDHEADANNO AS HEAD3
ON HEAD1.STRUCOBJN = HEAD3.STRUCOBJN AND HEAD3.NAME = 'ANALYTICS.DATACATEGORY'
WHERE ( HEAD1.NAME = 'ANALYTICS.DATACATEGORY' and HEAD1.VALUE = '#CUBE' )
ORDER BY ViewName