Calender Months to Fiscal Months
AbeJul 18 2012 — edited Jul 24 2012Hi All,
I am using OBI Apps 7.9.6.3. Currently my Quarters and months are based on Calendar year. I need to change the Calendar year to Fiscal year for all the SCM reports. All the financial reports are working based on fiscal year and is mapped to "Dim_W_MCAL_YEAR_D_Fiscal_Year"."MCAL_PER_NAME_YEAR”.
Where in SCM Years are mapped to "Dim_W_YEAR_D"."PER_NAME_YEAR"
I tried copying the Fiscal Year and Quater columns of Financial Reports to SCM reports from the presentation layer of RPD and changed the dashboard promts from year to fiscal year. But it didnt give me results .
Any thoughts?
Many Thanks