Clarity

  • 1.  Problem: Investment Baseline vs. Plan by Task

    Posted Aug 11, 2017 09:16 AM

    Hi there we try to execute the following jasper report en CA PPM 15.1 Investment Baseline vs. Plan by Task

     

    And we got the error: No matching records were found.

     

    Snap:

    List of scheduled Jobs

     

    Any Guess?? tips??

    Cheers!

    Pablo



  • 2.  Re: Problem: Investment Baseline vs. Plan by Task

    Broadcom Employee
    Posted Aug 11, 2017 09:44 AM

    Do you have baseline project?

     

    Thanks

    Senthil



  • 3.  Re: Problem: Investment Baseline vs. Plan by Task

    Posted Aug 11, 2017 09:49 AM

    Helo!

    Yes, check it out!

     

    Do you need any other info? or pics?



  • 4.  Re: Problem: Investment Baseline vs. Plan by Task

    Posted Aug 11, 2017 10:25 AM

    Hi Pablo,

     

    For this report there are some pre-requisites, in previous screenshot you had shown us that the Load Data Warehouse both Full load and incremental are running in the system.

    Additionally could you check on the below details:

     

    Could you check the following table -> dwh_inv_task_hierarchy , if it is being populated post run of the load Data Warehouse jobs ? The phase / task grouping present in the report is dependent on this table

    Is the time slices in the system regularly getting updated, specifically check for -> MONTHLYRESOURCEBASECURVE , MONTHLYRESOURCEACTCURVE, MONTHLYRESOURCEESTCURVE

    Also surely the project is having resource / roles assigned to tasks present in the project

     

    Regards,

    Samik



  • 5.  Re: Problem: Investment Baseline vs. Plan by Task

    Posted Aug 11, 2017 11:16 AM

    Samik i share the info. The Table, The Time Slices, and the schedule, its a testing purpose project. Regards

     

     

     

     

     

    Cheers!

    Pablo



  • 6.  Re: Problem: Investment Baseline vs. Plan by Task

    Posted Aug 18, 2017 05:17 AM

    Hi, try to run one of the earned value jobs.

    I think that there's a relation but not 100% sure it will effect the report.

    worth trying,

    David C



  • 7.  Re: Problem: Investment Baseline vs. Plan by Task

    Posted Aug 24, 2017 02:39 PM

    No, same behavior

     

    Any clue?



  • 8.  Re: Problem: Investment Baseline vs. Plan by Task

    Posted Aug 18, 2017 08:45 AM

    Can you check that all the prerequisites are satisfied?

     

    Report Prerequisites

    Verify that you have completed the following prerequisites before you run this report:

    • The Load Data Warehouse and Load Data Warehouse Access Rights jobs must be run before you run this report. If the Data Warehouse is not populated, the report displays a message that there are no matching records. Also, most of the report parameters do not display options.
    • The investment must have at least one resource or role assigned to a task for the investment to display in the report. For projects, the resource or role must be assigned to a task in the Gantt unless the project has an effort task with resources or roles automatically assigned. For investments other than the project, resources or roles added to the team are automatically assigned to an effort task for the investment. Note: Effort task is a task with the Task ID of '~rmw'.
    • The phase and task grouping in the report is dependent upon the task hierarchy (dwh_inv_task_hierarchy) table, which is populated by running the Load Data Warehouse job.
    • The baseline amounts are calculated based on the current baseline revision and the time slice with the name MONTHLYRESOURCEBASECURVE (Administration/Data Administration-Time Slices).
    • The actual amounts are calculated based on the time slice with the name MONTHLYRESOURCEACTCURVE (Administration/Data Administration-Time Slices).
    • The ETC amounts are calculated based on the time slice with the name MONTHLYRESOURCEESTCURVE (Administration/Data Administration-Time Slices).

     

     

    NJ