search cancel

NBI_DIM_CALENDAR_TIME table population


Article ID: 141405


Updated On:


Clarity PPM SaaS


Data in NBI_DIM_CALENDAR_TIME  currently only has data to April -2023.  Why?

How is this table populated?




The NBI_DIM_CALENDAR_TIME populates when the Datamart Extraction job runs.

This particular table holds dates that are used in Time Scaled Value grids.

These grids only go out so far due to an internal limitation.

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) 




Thiis is how the internal code is designed to populate the table


Additional Information

Clarity PPM: How Do the Time Scale Values Settings Work?