How Are The Datamart Tables Populated?
Article ID: 27009
Updated On:
Products
Issue/Introduction
The 'Datamart Rollup - Time Facts and Time Summary' job is a job that populates tables for facts consumption.
The 'Datamart Extraction' job should be successfully executed first so that prerequisite data is populated.
Resolution
The Datamart Extraction job populates the following tables:
NBI_DIM_OBS
NBI_DIM_FISCAL_TIME
NBI_DIM_CALENDAR_TIM
NBI_DIM_OBS_FLAT
NBI_PRT_FACTS - stores daily project, resource and task information for each project
NBI_PROJECT_CURRENT_FACTS
NBI_R_FACTS - stores daily resource information. It stores one row for each resource for each day
The Datamart Rollup job populates the following tables:
NBI_ROLLUP_SQL
NBI_PM_PT_FACTS
NBI_FM_PT_FACTS
NBI_RT_FACTS
NBI_PM_PROJECT_TIME_SUMMARY
NBI_FM_PROJECT_TIME_SUMMARY
NBI_RESOURCE_TIME_SUMMARY
Additional Information
Extract project management time facts and summary
The job populates the data in the PROJECT Management Time Facts and Time Summary tables. The program retrieves the data from the NBI_PROJECT_CURRENT_FACTS table (populated by the Datamart Extraction job) for the CURRENT period and if data exists in the Rollup for the prior period, the program will update the data for that period. The program creates two types of periods: the prior or current ISO week and the prior or current calendar month. If the Datamart Rollup job is successful, consistently, you can build historical Project Management rollup date for use in user-defined reports and portlets.
Tables populated by this option: NBI_PM_PROJECT_TIME_SUMMARY, NBI_PM_PT_FACTS
Extract financial management time facts and summary
The job populates the data in the FINANCIAL Management Time Facts and Time Summary tables. The program retrieves the data from the NBI_PROJECT_CURRENT_FACTS table (populated by the Datamart Extraction job) for the CURRENT Fiscal (monthly) period ONLY. If the Datamart Rollup job is successful, consistently, you can build historical Financial Management rollup data for use in user-defined reports and portlets.
Tables populated by this option: NBI_FM_PROJECT_TIME_SUMMARY, NBI_FM_PT_FACTS
Extract resource time facts and summary
The job populates the data in the RESOURCE Time Facts and Time Summary tables. The program retrieves the data from the Time Slice tables. The program checks for a "first-time" run. If this is the first-time the rollup resource tables are populated, then the program will populate records as far back as the 'From Date' in the current set of sliced records. After the "first-time" runs, the program will rebuild (rollup again) data in the Resource Time Facts and Time Summary tables for the prior 8 periods. The 8 periods are calculated as a number of ISO weeks between 8-12 (rounded up) based on the current date. Also, the 8 periods are calculated as a number of calendar months between 2-3 (rounded up) based on the current date. Since the Datamart Rollup job behaves in the same manner as the Datamart Extraction job for the Resource Rollup data, no historical information is retained. The Resource Rollup data is rebuilt each time the Datamart Rollup job is successfully executed.
Tables populated by this option: NBI_RESOURCE_TIME_SUMMARY, NBI_RT_FACTS
Based on the information provided below, it is recommended that the following is performed to ensure consistency:
Ensure that ALL daily Time Slice definitions have a 'From Date' for the first day of the month, at least 3 months prior to the first day of the current month.
Feedback
