NBI_DIM_CALENDAR_TIME

book

Article ID: 141405

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

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

 

 

Cause

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) 

 

 

 

 

Resolution

This is the limit set internally and cannot be changed.  

 

Additional Information

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