Many developers working with SAP Datasphere and with an SAP BW background have the requirements to calculate current-year, previous-year, current-month, or year-to-date measure values dynamically based on user input.
We have such a requirement as well.
Users need to enter a Reporting Month and Reporting Year on the frontend.
Then based on the input a set of restricted measures are calculated
- MTH means Year = Reporting Year and Month = Reporting Month
- YTD means Year = Reporting Year and Month <= Reporting Month
- PY-MTH means Year = Reporting Year -1 and Month = Reporting Month
- PY-YTD means Year = Reporting Year -1 and Month <= Reporting Month
- PY (Total Previous year) means Year = Reporting Year -1
Furthermore, the default values for Reporting Month and Reporting Year should not be arbitrary. They should be determined based on the last closed period in our CO Closing Timetable.
#abap