Transient BEx query is invisible on CMC

47 Views

Hello all,

I created CDS views with annotations as such:

1. Private view:

@AbapCatalog.sqlViewName: 'zcds_hier_p_M'

@ClientDependent: true

@AbapCatalog.compiler.compareFilter: true

@EndUserText.label: 'Private View for Hierarhcy'

@VDM.viewType: #BASIC

@Analytics.dataCategory: #DIMENSION

@Analytics.dataExtraction.enabled:true

@AccessControl.authorizationCheck: #NOT_REQUIRED

2. Interface view:

@AbapCatalog.sqlViewName: 'zcds_hier_I'

@ClientDependent: true

@EndUserText.label: 'Interface view for Hierarchy'

@AccessControl.authorizationCheck: #NOT_REQUIRED

@Analytics.dataCategory: #CUBE

@VDM.viewType: #COMPOSITE

@Analytics.dataExtraction.enabled: true

@Hierarchy.parentChild: [{name: 'Organization', recurse : {parent: 'Manager', child: 'name'}}]

3. Consumption view:

@AbapCatalog.sqlViewName: 'zcds_hier_c'

@ClientDependent: true

@EndUserText.label: 'Consumption view for Hierarchy'

@Analytics.query: true

@VDM.viewType: #CONSUMPTION

@Analytics.dataExtraction.enabled: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

The architecture is as follows:

The consumption view 'zcds_hier_c' selects data from the interface view 'zcds_hier_i'.

The interface view 'zcds_hier_i' selects data from the private view 'zcds_hier_p_m' and the transaction table 'ztransactions'.

The private view 'zcds_hier_p' selects data from the master table 'zemployees_all'.

Both the table 'ztransactions' and 'zemployees_all' are custom development tables.

I was trying to test CDS annotations for Hierarchy, and I was hoping to see the analytics query from the BI client with those configurations above.

But what I see is the infoProvider of the Interface view '2CZCDS_HIER_I' and the other infoProvider of the Private view '2CZCDS_HIER_P_M'.

That's all and I cannot find the transient BEx query of the Consumption view '2CZCDS_HIER_C', which I was hoping very very much to see.

Are my annotations wrong? Or is there anything I should do with the custom tables if I want to expose a query with the data from those tables?

Or any other things that I should care about?

Anybody's helping hand would be really really appreciated...

Thank you very much in advance!!! 🤣🤣

Bests,

MJ