Kristin_Schroer

CA PPM Tuesday Tip: Importance of running the Update Business Objects Report Tables Job

Discussion created by Kristin_Schroer Employee on May 26, 2015
Latest reply on May 27, 2015 by navzjoshi00

Are you using Business Objects? If so, one of the ways to prevent report issues is to ensure you are running the Update Business Objects Report Tables job at least once per day.  If not, you can run into multiple reporting issues including: reports not showing any data, reflecting recent PPM data changes, or data showing as hours when FTE is expected, etc.

Below are steps on how to run the Update Business Objects Report Tables job:

1.  In PPM, go to Home, then Reports and Jobs.

2.  Next, click on the Jobs tab.

3.  Click on the Update Business Objects Report Tables job.

4.  Check the appropriate check boxes under the Parameters section.

Note: Which options that should be checked under parameters is dependent on the report and parameters being used in the report. For Example, the Update Reporting Calendar option updates the report calendar table. 

5.  Click Submit to generate the job. If the job hasn’t run in a while it may take longer to run. It may also take longer to run at the start of each calendar year.

 

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

 

CA Clarity™ PPM Solution Pack Index (PPM Solution Pack Documentation Home Page). In the Product Guides referenced on this page, you can find additional prerequisites required based on report. https://support.ca.com/irj/portal/anonymous/phpsupcontent?contentID=e555020a-ccd5-43dd-ba00-8fa1e4cdd7a4&productID=5590  -

PPM: How often should the Update Business Objects Report Tables job be run? - http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1323267.aspx

Clarity: When running a report with unit type set to FTE, the data returned switches from FTE to hours - http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec618028.aspx

Clarity: Resource Skills report not showing data - http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec618035.aspx

Outcomes