What is the purpose of the Resource - Include in Datamart Flag ?

Document ID : KB000027070
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

What is the purpose of the Resource - Include in Datamart Flag?

Answer:

When a user elects to exclude a resource from the Datamart, this option only affects the resource-specific information in the Datamart in the NBI_RESOURCE_CURRENT_FACTS and all the Resource Facts information tables. It does not affect the Project information in the NBI_PROJECT_CURRENT_FACTS table or other Datamart project tables. The execution of the 'Datamart Extraction' job takes the information from the SRM_RESOURCES table and does not check for this flag for populating Project fact tables. Therefore, the Actual Hours reflect all actual hours booked by all resources on the Project. This ensures that all Project Summary information includes all effort recorded for all resources on the project.

Additional Information:

Reference TEC435612 : Datamart: Technical White Paper