Calendar
Dimension table for the default calendar
DE: Kalender
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| DateBK | Datum | dateTime | |
| TimeBK | TimeBK | dateTime | |
| DateDisplay | Datum (display) | string | |
| DateDisplayLong | Datum (lang) | string | |
| DateDisplayShort | Datum (kurz) | string | |
| Year | Jahr | int64 | |
| Halfyear | Halbjahr | string | |
| YearHalfyear | Jahr-Halbjahr | string | |
| Quarter | Quartal | string | |
| YearQuarter | Jahr-Quartal | string | |
| QuarterDisplayLong | Quartal (lang) | string | |
| QuarterDisplayShort | Quartal (kurz) | string | |
| Month | Monat | int64 | |
| MonthDisplay | Monat (display) | string | |
| MonthDisplayLong | Monat (lang) | string | |
| MonthDate | Monat (Datum) | dateTime | |
| YearMonth | Jahr-Monat | string | |
| Week | Woche | int64 | |
| WeekDisplay | Woche (display) | string | |
| YearWeekDisplay | Jahr-Woche (display) | string | |
| ISO_Week | ISO Woche | int64 | |
| ISO_WeekDisplay | ISO Woche (display) | string | |
| DayOfMonth | Tag im Monat | int64 | |
| DayOfYear | Tag im Jahr | int64 | |
| Weekday | Wochentag | int64 | |
| WeekdayDisplay | Wochentag (display) | string | |
| WeekdayDisplayLong | Wochentag (lang) | string | |
| FY_DateBusinessKey | Datum (Fiskaljahr) | dateTime | |
| CurrentDate | Aktuelles Datum | int64 | |
| CurrentMonth | Aktueller Monat | int64 | |
| PrevMonth | Vormonat | int64 | |
| CurrentYear | Aktuelles Jahr | int64 | |
| CT_Operation | CT_Operation | string | |
| WeekStartDate | WeekStartDate | dateTime | |
| Day Offset | Tagesversatz | int64 | Shows the number of days between each date and today (0 = today, -1 = yesterday), making it easy to filter or analyze data relative to the current day. Useful for rolling and relative-date reporting. |
| Month Offset | Monatsversatz | int64 | Shows the number of months between each date's month and the current month (0 = this month, -1 = last month), helping filter or compare data relative to the current month. Useful for rolling monthly analyses. |
| Year Offset | Jahresversatz | int64 | Shows the number of years between each date's year and the current year (0 = this year, -1 = last year), helping filter or compare data relative to the current year. Useful for year-over-year reporting. |
| Is Last Date of Month | Ist letzter Tag des Monats | int64 | Indicates whether a date is the last day of its month (1 = yes, 0 = no). Useful for month-end calculations and filtering to month-end values. |