Skip to Content
Jul 09, 2019 at 03:52 PM

Date interval in Analysis for office CDS view exposed as OData


Hi, We are on S4HANA 1610. We have Analysis for office CDS Consumption view which is exposed as OData using annotation OData.publish:true.

This CDS view has one mandatory filter defined as below.

@AnalyticsDetails.query: {axis: #ROWS,variableSequence: 10} @Consumption.filter: {selectionType: #INTERVAL,multipleSelections: true,mandatory: true} @EndUserText.label: 'Shipment Created Date' ShipmentCreatedOn

We have ODaa URL like below working fine.

/sap/opu/odata/sap/ZWHLLE_C_SHIPDETAIL_CDS/ZWHLLE_C_SHIPDETAILResults?$filter=ShipmentCreatedOn eq '20190101'But we want to pass date range. In Analysis for office it is working fine with date range but in OData when I try to use gt etc then it says it is not supported.