Calendar Dimension

Calendar Dimension

You can add a Calendar Dimension from within AC:

1. Right-click → Add Calendar Dimension
2. Define start and end years (e.g., 1970–2099)

AC generates all necessary date attributes (Year, Month, Quarter, Week, etc.)

AC also provides macros (UpdateDimDate, GetDimDate) to automatically map date fields from your source tables to the calendar dimension.