SAP Analytics Cloud MTD calculation according to CDS input date

[former_member302630]

Hi All,

SAC Story on S/4 CDS views sourced models.

CDS view prompt has a prompt on Posting Date which user will change as per his/her wish. According to this date MTD calculations should happen. When I chose current month filter on posting date in restricted measure, I understood that I always get current month as of calendar today and not as of user input in posting date.

How can I make a user input based MTD field?

Cleo

[VijayetaSharma · Accepted solution]

Hi,

Below blog explain the setup steps required to allow MTD and similar time based reporting.

MTD, YTD, YTG (YearToGo) Calculations in SAP Analytics Cloud

Filtering Data by Time in SAP Analytics Cloud

Thanks,

Vijayeta