The system that I'm going to describe in this post is an OBIA 7.9.6.1 which is integrated with Oracle EBS 12.1.1 source system. The current 2013 fiscal year ends on 03/02/2013. The fiscal calendars (both source and generated) should be extended till the end of 2016 fiscal year which will be on 31/01/2016. The Gregorian calendar should be extended till the 31/12/2016 accordingly.
The OBIA supports Enterprise or Global calendar (cross-functional reporting calendar, can be fiscal or Gregorian), Fiscal calendar (can be accounting or financial), Gregorian calendar, 4-4-5 and 13 period calendars. The Time Dimension that represents those calendars uses the following tables from Oracle Business Analytics Warehouse (OBAW):
Gregorian Calendar
- W_DAY_D
- W_WEEK_D
- W_MONTH_D
- W_QTR_D
- W_YEAR_D
- W_MCAL_DAY_D
- W_MCAL_WEEK_D
- W_MCAL_PERIOD_D
- W_MCAL_QTR_D
- W_MCAL_YEAR_D
- W_ENT_WEEK_D
- W_ENT_PERIOD_D
- W_ENT_QTR_D
- W_ENT_YEAR_D