Skip to Content

Dates and Date Dimension in CDS

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 27 at 03:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded