NBI_DIM_CALENDAR_TIME table population
search cancel

NBI_DIM_CALENDAR_TIME table population

book

Article ID: 141405

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

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

How is this table populated?

 

 

Cause

The NBI_DIM_CALENDAR_TIME populates when the Datamart Extraction job runs.

The related stored procedure is NBI_POPULATE_CAL_DIM_SP

The stored procedure build out the different types of periods 

MONTH = CURRENT DATE + 1188 days  (3 years, 3 months). These may extend further based on the time slice rollovers.

Other values such as Daily and Weekly are determined by the min from_date on the system slices and can vary.

Many times these will go out somewhat further than the monthly periods.

 

 

 

 

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 unless you have the approved time slice extension.

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) 

When the Datamart job is run the following procedure is called: NBI_POPULATE_CAL_DIM_SP

 

 

 

Resolution

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

 

Additional Information

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