Fiscal calendar definitions are based on company reporting requirements and can start on any date. In this calendar, a week has seven days. The 12-month reporting period includes two months of four weeks and one month of five weeks, in a repeated three-month quarterly pattern. When you select the three-month pattern of each quarter (4-4-5, 4-5-4, or 5-4-4 weeks), the months are defined based on the pattern specified. If the year has 53 weeks, one of the months can have an extra week.
The Fiscal calendar builds your selected time depths into the calendar dimension hierarchy. Select any from the following time depths:
Year
Semester
Trimester
Quarter
Month
Week
Day
To create a fiscal calendar hierarchy:
Right-click the appropriate folder in the Metadata Navigator and select New, then Calendar Hierarchy to launch the Edit Calendar Hierarchy dialog box.
In Hierarchy Name, enter the name for the fiscal calendar hierarchy.
From Calendar, select Fiscal and click the Semantic Rules link.
In Year Semantic Rules and Month Semantic Rules, adjust how your fiscal year is structured by choosing from the following options.
The selection you make in Year Semantic Rules affects the options in Month Semantic Rules.
All options use the Month, Week, or Day drop-down boxes in this group.
Year Semantic Rules
Starting week - number in month—Select the Month and Week in which your fiscal year starts.
Ending week - number in month—Select the Month and Week in which your fiscal year ends.
Year starts on a week that includes a specific date—Select the specific date from Month and Day. The fiscal year begins on the first day of this week containing this date.
Year ends on a week that includes a specific date—Select the date from Month and Day. The fiscal year ends on the last day of the week containing this date.
Year starts on the week on or immediately following a specific date—Select the date from Month and Day. The fiscal year begins on the first day of the week on or immediately following this date.
Year starts on a specific date—Select the date from Month and Day. The fiscal year begins on this date.
Enforce 53 weeks—The first or last week, depending on which has been chosen, will have days added to make a complete week. The days will be taken from the adjacent fiscal year.
Enforce 52 weeks—The first or last week, depending on which has been chosen, will be removed from the calendar and moved to the adjacent fiscal year
Month Semantic Rules
Some of these options may be unavailable depending on the year semantic rule selections.
Starting week number specified—The starting week number is specified by the selection in Week above.
Month always starts on a week that includes a specific date—The date is specified by the selection in Day above.
Month starts on the week on or immediately following a specific date—The date is specified by the selection in Day above.
By Qtr-Month pattern—The pattern of weeks per month for each quarter is specified by the drop-down box. In a 53-week year, you can specify the month that includes the extra week in the “Month having extra week” drop-down box.
Month always starts on a specific day number—The date is specified by the selection in Day above.
Click OK to return to the Edit Calendar Hierarchy dialog box.
In Modeling Parameters, enter the start and end dates of the period that you are modeling, and select a First day of week.
To define time depth, see Defining Time Depth.
Time depth applies to all calendar types.
To define day attributes, see Defining Day Attributes.
Day attributes apply to all calendar types.
To set linked value attributes, see Linked Value Attributes.
Linked value attributes apply to all calendar types.