Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

VDM.VIEWTYPE for ANALYTICS.DATACATEGORY #CUBE

sap_cohort
Active Contributor
0 Kudos

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
0 REPLIES 0