Content provided by SumanPramanik
Yes. The Update Business Objects Report Tables job is required for reports that display resource skill relationships.
The job must be run when a skill is created, deleted, renamed, or modified in any way in the skills hierarchy (Administration/Data Administration-Skills Hierarchy). It does not have to be run after associating skills to resources.
All other options for this job are NOT Required because the associated tables for these options are updated when the 'Load Data Warehouse' job executes. This applies if you are going to run both jobs.
See the PMO Accelerator Advanced Reporting Product Guide in the CA PPM Advanced Reporting and Database Schema Index page.
Here is a list of Reports that use the PPM database (with exceptions noted)
These reports do not select the data from the data warehouse because not all the data in PPM is available in the data warehouse.
If you are not using the DWH yet, you will need to configure the Entity set up to run the 'Update Business Object Report Tables' job. If you do not run the 'Load Data Warehouse' job, when you run the 'Update Business Object Report Tables' job be sure to select all parameter options. As noted above, the other options on the 'Update Business Objects Report Tables' job are not required if the 'Load Data Warehouse' job is executed, because both jobs will update the same tables (except for the Skills Index table).
Thanks for sharing this useful info, Kathryn
Following our recent Dev environment upgrade to 14.2 we were not ready just yet to configure the DWH and Jaspersoft.
Every day in the job logs dashboard we would see the 'Update Business Object Report Tables' job failing and it was simply because we did not have the language and entity set in the parameter options. Once we did this the job completed successfully.
Thanks your discussion encouraged me to write this tip and Kathryn helped me
Could you please elaborate more on setting the languages and entities in the parameters options for the Update Business Object Report Tables job to run successfully?
Thanks & Regards,
The entity and language set up is required in order to have data ware house working. Also the job updates few tables and the reports are developed based on that. More documentation are available in Install guide from 14.2 onwards