Would someone know how the table NBI_DIM_CALENDAR_TIME gets populated?
Inside our environment we have created fiscal periods ranging from December 2010 to December 2015. For some reason, the periods on the table NBI_DIM_CALENDAR_TIME starts only at September 2012. The job 'Extract Datamart' is scheduled to run every day. Maybe we're missing something in order to create the rest of the periods in the table?
Thanks in advance.