CDS View vs CDS View Entity in Query Browser

[Tamas_B]

Dear Community,

I am trying to find my way around the query browser that is built in to the Fiori Launhcpad.
We are searching for solutions to enable reporting via CDS Views within the Fiori Launchpad.
Within the Query browser I was able to find standard and custom CDS Views, even built a very simple CDS View myself and I could retrieve data which is superb.
My issue is that since CDS Views are considered depracated as of ABAP 7.57 (as far as I know), I am trying to implement CDS View entities for the same purpose.

I used the appropiate annotations:

@analytics.query: true
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #CONSUMPTION

The view entity is still not listed in the query browser.
Did I miss some additional annotations or is it simply not possible for a view entity to be applied as an analytical query?

Thank you for your feedback!

Kind regards,
Tamas

[junwu]

can you share the code how your entity is defined? not just those header annotation.

[Tamas_B]

Query CDS View Entity:

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Generic Custom Sales Order Data Entity'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #D,
    sizeCategory: #S,
    dataClass: #MIXED
}
@Analytics.query: true
@Analytics.dataExtraction.enabled: true

@VDM.viewType: #CONSUMPTION
 
@Consumption.valueHelpDefault.fetchValues: #AUTOMATICALLY_WHEN_DISPLAYED
@OData.publish: true

define view entity Z_SO_DATA_QUERY_ENTITY 
  with parameters
    @Consumption.valueHelpDefinition:                    // Annotation to link parameter with CDS view which will help to generate Text
    [ {
    entity: { name: 'Z_SALES_ORG_VAL_HELP',
          element: 'Vkorg'}
    }]
    p_vkorg     : vkorg,
    @EndUserText.label: 'From creation date'
    p_crea_from : datum,
    @EndUserText.label: 'To creation date'
    p_crea_to   : datum

  as select from Z_SALES_ORDER_DATA_CUBE (p_vkorg:$parameters.p_vkorg,
                                          p_crea_from:$parameters.p_crea_from,
                                          p_crea_to:$parameters.p_crea_to)
{
  key vbeln,
      auart,
      vkorg,
      erdat,
      @Semantics.amount.currencyCode: 'waerk'
      netwr,
      waerk
}

Cube CDS View Entity:

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Generic Custom Sales Order Data Cube'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@Analytics.dataCategory: #CUBE
@VDM.viewType: #CONSUMPTION

define view entity Z_SALES_ORDER_DATA_CUBE
  with parameters
    @Consumption.valueHelpDefinition:                    // Annotation to link parameter with CDS view which will help to generate Text
    [ {
    entity: { name: 'Z_SALES_ORG_VAL_HELP',
          element: 'Vkorg'}
    }]
    p_vkorg : vkorg,
    @EndUserText.label: 'From creation date'
    p_crea_from : datum,
    @EndUserText.label: 'To creation date'
    p_crea_to : datum
    
  as select from vbak as k
    join         vbap as p on k.vbeln = p.vbeln
{
  key k.vbeln      as vbeln,
      k.auart as auart,
      k.vkorg      as vkorg,
      k.erdat      as erdat,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'waerk'
      sum(p.netwr) as netwr, //Nettowert der Auftragsposition in Belegwahrung,
      p.waerk      as waerk
}
where
//      k.auart = $parameters.p_auart
//      and 
      k.vkorg = $parameters.p_vkorg
      and k.erdat between $parameters.p_crea_from and $parameters.p_crea_to
      
group by
  k.vkorg,
  k.vbeln,
  k.auart,
  k.erdat,
  p.waerk

[junwu]

I believe you are not using latest regarding query

please follow this one.

https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/cds-analytical-projection-vie...

[Tamas_B]

Dear Junwu,

the analytical projection view is unfortunately not supported yet in our backend becuase of which the linked approach although promising, unfortunately not yet applicable. I think for now I will stick to simple vies even if depracated and remodel when the time is right.

Thank you for your assistance!

Greeting,
Tamás