on 09-12-2007 7:05 PM
Hi,
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,
Hi Experts,
Please help urgently. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Have you used Fiscal Yaer variant in your query?
When you use these variables you should restrict querieswith correct fiscal yaer Variant.
Jaya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.