Skip to Content
0
Dec 05, 2022 at 06:22 PM

VDM.VIEWTYPE for ANALYTICS.DATACATEGORY #CUBE

85 Views Last edit Dec 06, 2022 at 07:55 PM 3 rev

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