We have calculation view(CV) -> composite provider(CP). I have to built a bex query on CP with below requirement:
SAP HANA studio 2.3.
Input parameter in view: Deal: 123 And ACT_Date: <=3/31/2018 (user can enter any input date, I have taken <= sign to consider all records for processing)
Report output should display Actual_YTD only for Rep period:12. Report layout as below:
User want to see data for Deal 123, YTD and tenant.
From ACT_Date, YTD data should be split by latest year wise in 3 columns always. And if you see input date has no reference with data set returned with <=3/31/2018 selection.
I can not do any customer exit in Bex query because input date does not give any reference to ACT_Date and YTD. Requesting you to help to know how these yearly split columns can be derived at hana calculation view level to display respective YTD amount.
One more example for reference: User input date ACT_Date <= 12/31/2017