cancel
Showing results for 
Search instead for 
Did you mean: 

Dates and Date Dimension in CDS

aalexis
Participant
0 Kudos

Hello All,

I have a need to combine Sales, Billing and Delivery KYFs and display them by WTD, MTD, QTD and YTD. Each of the measure come with it's own date. Sales Order Date, Billing date and Delivery Dates. if I create them in individual models I will be able to get all time periods associated with the dates. When combining in a dashboard with common filter it will have issues in using the time parameter. Should I union them as Transaction dates, Months, Qtr, Year and use a column to differentiate as S, B and D and use as a restricted KYF's in the dashboard?

This will have to be done using ABAP CDS and Fiori front end.

I have not done this yet, but any suggestions?

Appreciate your input.

Thanks,

Arthur.

Accepted Solutions (0)

Answers (1)

Answers (1)

deodutt_dwivedi
Active Participant
0 Kudos

Hi Arthur,

I Could not figure out the complete requirement but you can join SO, Billing and Delivery and create calculated measures in the CDS consumption CDS view for WTD, MTD so on in the backend itself. Additionally in your Query CDS view you can handle the redundancies using exception aggregation features. for using this you will need to have clarity on the granularity of the data required for your dashboard.

Regards,

Deo