Dear Experts,
I am facing a weird issue in one of my Bex Reports.
The requirement is to fetch the data of User Input Year - 1. For example if the user enters 2017 , then the data of 2016 is fetched based on few restriction on value type, currency type, version.
I have created customer exits for value type, currency type, version and Cal month, since there are multiple combinations of restrictions.
I can see that , the report is fetching data for Current year. I.e if User enters Current year , the data of Current year - 1(2015) is displayed, but the
if the user enters 2017 or 2018, the report doesn't fetch any data for the key figure. It only displays blank.
I have debugged my customer exits and the reports using RSRT.
I have also checked the Key figure definition value in RSRT . Everything is displaying as expected, but I get no data.
There are other queries based on the same Multiprovider, and they are all displaying data for same set of inputs. Just that they are directly fetching 2016 data if the User enters 2016 in selection screen.
Could you please help me, if you have got any idea on the issue.
Thanks in advance!
Regards,
Vidya