We are developing six new BCS queries. We have already have about 30 reports.
1. We are using the Fiscal Year variable (0FISCYEAR) - 0P_FYEAR in most of the queries. In the new reports, particularly in one query, the previous year is not working with -1 offset value. but, the same variable is working in other new reports for previous year. Please help how to rectify the issue.
2. I have started trying many options in QA environment and found that there was a option to choose CONSTANT SELECTION in the 0FISCYEAR. So, I tried to select the Constant selection and found that the PREVIOUS YEAR IS WORKING for the query, for which earlier it was not working. Now, my another issue is that previous year is not working for all other queries which we have used the 0P_FYEAR as variable.
Since I have tried this in QA, all the reports in QA are not working for previuos year. Please advise urgently to correct the same.
Thanks & Regards,