CDS(AMDP) Resource Usage

[EhsanGhasemi]

Hello everyone,

I have a Cube that is consumed in MS Power BI. This Cube uses a CDS table function. When we try to retrieve data from this Cube, MS Power BI creates about 20 sessions in SM04 and consumes about 4-5 DAI in SM50, resulting in the production server slowing down significantly.

Cube annotation

@EndUserText.label: 'xxxxx'
@VDM.viewType: #COMPOSITE
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: ['_CreatedByUser']
}
@AbapCatalog: {
  sqlViewName: 'xxxxx',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
  usageType: {
    dataClass:      #MIXED,
    serviceQuality: #D,
    sizeCategory:   #XL
  }
}
@Analytics.dataCategory: #CUBE
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations:true
}

[EhsanGhasemi]

I notice this issue occurs when I utilize the table function; otherwise, only one DAI is used in SM50.