Data in NBI_DIM_CALENDAR_TIME currently only has data to April -2023. Why?
NBI_DIM_CALENDAR_TIME populates when the Datamart Extraction job runs.
This particular table holds dates which as used in TSV grids.
These grids only go out so far.
Quarterly: 12 periods (4 quarters in the past, start of current quarter + 8 quarters into the future)
Monthly: 36 periods (12 months in the past, start of current month + 24 months into the future)
Weekly: 16 periods (2 weeks in the past, the current week + 13 weeks from the current week)
Daily: 28 periods (7 days in the past, start of current day + 21 days into the future)
This is the limit set internally and cannot be changed.