Manage KPI Report issue with dynamic passing parameterized CDS values

[former_member1071835]

We had created a parameterized CDS view with dynamic values as default values of parameters. We had used the below annotations where ZC_CDS_I_DATE_BUCKET is another CDS view based on this I am deriving the parameter values but the default values are not getting populated in the Manage KPI Reports app. Below are the annotations anyone has encountered the issue for achieved the requirement before

@Environment.systemField: #SYSTEM_DATE

@EndUserText.label: 'Todays Date'

@AnalyticsDetails.query.variableSequence: 1

p_keydate : abap.dats,

@AnalyticsDetails.query.variableSequence: 2

@Consumption.derivation: { lookupEntity: 'ZC_CDS_I_DATE_BUCKET',

resultElement: 'FirstDayofMonth',

binding: [{ targetElement: 'CalendarDate',

type:#PARAMETER ,

value: 'p_keydate' }]

}

P_StartDate: /srmsmc/puc_spend_valid_from

[EC]

Hi, 

I believe the derivation annotation only works in combination with annotation @consumption.hidden: true.