Clarity PPM1

Expand all | Collapse all

CA PPM Tech Tip: Updating Report Tables

  • 1.  CA PPM Tech Tip: Updating Report Tables

    Posted 07-21-2015 05:11 PM

    Content provided by SumanPramanik

     

      

    Is the 'Update Business Objects Report' job still required for any Jaspersoft Reports?

     

        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.

     

     

    Do all the JasperSoft reports uses Data Warehouse?

     

    No

     

    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.

     

    • *Missing Time  (only the Availability hours comes from CA PPM tables, rest of report is from the data warehouse)
    • Project Change Request Register
    • Project Issue Register
    • Project Risk Register
    • User Access Rights
    • User Access Rights Detail
    • User License and Activity
    • User License and Activity Detail
    • Project Task Dependencies
    • Resource Skills (requires 'Update Business Objects Report Tables' job)

     

     

    What if we are not using the Data Warehouse (DWH) yet? What configuration is still required?

     

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



  • 2.  Re: CA PPM Tuesday Tip: Updating Report Tables

    Posted 07-22-2015 01:09 AM

    Thanks for sharing this useful info, Kathryn

     

    Regards

    NJ



  • 3.  Re: CA PPM Tuesday Tip: Updating Report Tables

    Posted 07-22-2015 10:43 AM

    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.



  • 4.  Re: CA PPM Tuesday Tip: Updating Report Tables

    Posted 07-22-2015 10:46 AM

    Hi Colin,

     

    Thanks your discussion encouraged me to write this tip and Kathryn helped me

     

    Regards

    Suman Pramanik



  • 5.  Re: CA PPM Tech Tip: Updating Report Tables

    Posted 02-05-2016 01:48 AM

    Hello,

     

    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,

    Subhashini Guruju



  • 6.  Re: CA PPM Tech Tip: Updating Report Tables

    Posted 02-05-2016 01:51 AM

    Hi Subhashini,

     

    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

     

    Regards

    Suman Pramanik