The Date dimension defines the start and end dates of the model's timeline. It also specifies the granularity of the time units used in the model (year, quarter, month, week, or day.)
You can specify a default time hierarchy to display in stories, and optionally configure the date dimension to organize data by fiscal year instead of calendar year. Also, a model can contain more than one date dimension if needed.
The supported weekly time patterns are:
You can customize date dimensions members, hierarchies and properties to make time more flexible and suited to your planning and analytical needs. Flexible time hierarchies help you plan and analyze data along an individual time hierarchy. They also allow for company specific fiscal year calendars.
The concept of special periods refers to periods that are used to store adjustments postings. Some companies, for example, have a 12 month calendar along with 4 special periods … one for each quarter.
Date dimensions can be maintained either manually or automatically by the system.
Leaving the management to the system means that the dimension's values are generated from the parameters within the Dimension Settings panel in the Modeler, and in the model preferences. Conversely, maintaining the date dimension manually allows you to edit the master data and manage all dimension members freely.
You can edit the dimension parameters just like you would with a standard date dimension. However, managing dimension members manually unlocks hierarchy management, the ability to create custom properties, and editing properties within the dimension view.
If you’ve set the date dimension to user-managed, you can edit the predefined hierarchies that come with the time granularity that are applied to the dimension.
You can add properties to date dimensions and specify dates of interest for your reporting or planning purposes, and account for specific periods like Holidays, or special sales seasons for instance.
Within a hierarchy, each property you create is assigned to a semantic type. A semantic type is a time unit assigned to a property within the hierarchy: Year, Half-Year, Quarter, Month, Period, Week, Day, and Other.