This calendar comes from the National Retail Federation and is modeled to analyze week over week data across years. It has a 4-5-4 quarter pattern with leap weeks every 5-6 years. The starting date differs from year to year, but it always falls in early February. When comparing year over year, it is standard practice to omit the first week of a 53-week year to normalize for the extra week while keeping the same set of holidays in both years. Fiscal calendars can include members on year, semester, quarter, month, week, and day time periods.
To create a retail 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 retail calendar hierarchy.
From Calendar, select Retail and click the Semantic Rules link.
In Month Semantic Rules, you can choose only By Qtr-Month Pattern and specify the following options:
Week Pattern—The pattern of weeks per month for each quarter
Month Having Extra Week—In a 53-week year, select the month that includes the extra week.
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.