Kristin_Schroer

CA PPM Tuesday Tip: Is the Datamart Extraction Job Required?

Discussion created by Kristin_Schroer Employee on Apr 21, 2015
Latest reply on Aug 26, 2015 by rybse01

Are you running the Datamart Extraction job on a consistent basis? If not, did you know even though you may not see issues now, you can start seeing issues later down the road? One example of an issue you might see: Time Scaled Value grids that previously showed data in portlets no longer show data. This can particularly happen after an upgrade. The job is required as it populates the core data points.

Reference Clarity PPM product documentation guides for information on Datamart Settings and Financial Management minimum configuration setup.

A few additional notes:

  • The job run activities are added to NBI_RUN_LOGS, however this only applies to Oracle databases.
  • The Datamart Rollup: Time Facts and Time Summary job is not required to run. All activities for this job update additional NBI tables that are meant for customers to use in custom reporting. The following tables are populated by this job:

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

For more information on this topic, please refer to the following KBs:

Outcomes