CalendarDate_DIM Table

Table used for quickly manipulating date data within 5 calendar years in the past and future in Cognos.

Table 1. Database columns for `CalendarDate_DIM` table
Database Column	Details
`Date`	Type: date. Key The date.
`Year`	Type: small integer. Key The year.
`Month`	Type: tiny integer. Key The year.
`Day`	Type: tiny integer The day.
`Quarter`	Type: tiny integer. Key The quarter.