Clarity PPM

Expand all | Collapse all

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

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

    Posted 04-21-2015 05:12 PM

    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:



  • 2.  Re: CA PPM Tuesday Tip: Is the Datamart Extraction Job Required?

    Posted 04-21-2015 07:15 PM

    Thanks for the tip Kristin!

    Kristin Schroer wrote:

     

    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:



  • 3.  Re: CA PPM Tuesday Tip: Is the Datamart Extraction Job Required?

    Posted 04-21-2015 11:22 PM

    Thanks for this tip, Kristin

     

    NJ



  • 4.  Re: CA PPM Tuesday Tip: Is the Datamart Extraction Job Required?

    Posted 08-21-2015 03:15 AM

    Hi Kristin,

     

    I couldn't find any reference in the tech-article regarding v.14.2 (where e.g. the DWH was added).

     

    Do you know if the Datamart Extraction as described in your article does apply to 14.2 alike?

     

    Many thanks,

    Sebastian



  • 5.  Re: CA PPM Tuesday Tip: Is the Datamart Extraction Job Required?

    Posted 08-21-2015 04:45 AM

    Having learned it the hard way

    " 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."


    also means that to get those core data points populated to start with you have to run the the datamart extraction (and have the datamart set up) once before you start getting data on some of the time scaled portlets.

    Then when the populated calendar run out you have to run the datamart extraction again even if you are on a test system where you do not neet the reports and such comingfrom the NB tables but need the time scaled portlets.



  • 6.  Re: CA PPM Tuesday Tip: Is the Datamart Extraction Job Required?

    Posted 08-26-2015 12:53 AM

    Hi Urmas,

     

    many thanks for that!

     

    Best regards,

    Sebastian