Project: Hierarchy: Financial Rollup does not rollup all costs - Detail View

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Issue:

Steps to Reproduce:

1. Create a project, for instance XYZ Online, starting on Apr/01/2011 and finishing on Jun/30/2011
2. Associate this project to a financial entity (department and location)
3. Create a Cost Plan starting in Apr/2011 and finishing in Jun/2011
4. Manually enter some costs, for instance, add values as expense for Apr, May and Jun (see screenshot)
5. Run Update Hierarchy Data job
6. Navigate back to project XYZ and verify project hierarchy tab - Select View: Detail (see screenshot)
   
   Project XYX Parent - Cost Plan
   
   

   <Please see attached file for image>

   
   
   Total Cost = 140,000.00
   
   Project XYX Parent - Hierarchy Tab without children
   
   

   <Please see attached file for image>

   
   
   
7. Create another project, for instance XYZ-Child, starting on Apr/01/2011 and finishing on May/31/2011
8. Associate this project to a financial entity
9. Create a Cost Plan starting in Apr/2011 and finishing in May/2011
10. Manually enter some costs, for instance, add values as expense for Apr and May (see screenshot)
11. Run Update Hierarchy Data job
12. Navigate back to project XYZ-Child and verify project hierarchy tab - Select View: Detail (see screenshot)
    
    Project XYX Child - Cost Plan
    
    

    <Please see attached file for image>

    
    
    Total Cost = 9,000.00
    
    Project XYX Child - Hierarchy Tab without children
    
    

    <Please see attached file for image>

    
    
    
13. Create a third project, for instance XYZ-Grand Child, starting on Feb/01/2011 and finishing on Nov/30/2011
14. Associate this project to a financial entity
15. Create a Cost Plan starting in Feb/2011 and finishing in Nov/2011
16. Manually enter some costs, for instance, add values as expense for Feb through Nov (see screenshot)
17. Run Update Hierarchy Data job
18. Navigate back to project XYZ-Grand Child and verify project hierarchy tab - Select View: Detail (see screenshot)
    
    Project XYX Grand Child - Cost Plan
    
    

    <Please see attached file for image>

    
    
    

    <Please see attached file for image>

    
    
    Total Cost= 6,500.00
    
    Project XYX Grand Child - Hierarchy Tab
    
    Basic View - shows Planned Cost as 6,500.00 = 200 + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1000 + 1100 (Cost Plan)
    
    

    <Please see attached file for image>

    
    
    Detail View does not show values for Feb/11 and Mar/11 (probably because of the time slice)
    
    

    <Please see attached file for image>

    
    
    
19. Navigate back to project XYZ Child, select the Hierarchy tab and add XYZ-Grand Child as a child project
20. Run Purge Temporary Hierarchy Data job with Clear all temporary data option followed by Update Hierarchy Data job
21. Give it some time...
22. In the Hierarchy tab select View: Detail (see screenshot) - it rolls up all costs correctly
    
    Project XYX Child - Hierarchy - Detail View after adding XYZ Grand Child to XYZ Child project
    
    

    <Please see attached file for image>

    
    
    It rolls up costs from April thru November but the Basic View shows totals from February thru November (6,500.00)
    
    

    <Please see attached file for image>

    
    
    
23. Navigate back to project XYZ-Online (XYZ-Parent), select the Hierarchy tab and add XYZ-Child as a child project
24. Run Purge Temporary Hierarchy Data job with Clear all temporary data option followed by Update Hierarchy Data job
25. Give it some time...
26. Navigate back to project XYZ-Online, select the Hierarchy tab, select View: Detail (see screenshot)
    
    Project XYZ - Parent - Hierarchy - Basic View after adding XYZ Child to XYZ Parent project
    
    

    <Please see attached file for image>

    
    
    Project XYZ - Parent - Hierarchy - Detail View after adding XYZ Child to XYZ Parent project
    
    

    <Please see attached file for image>

    
    
    It does not roll up costs from Jun/2011 through Nov/11
    
    Same view after configuring TSV field:
    
    

    <Please see attached file for image>

    
    
    44,400 + 45,500 + 60,000 = 149,900 ; this is different from 155,500.00 (Basic View)
    
    Note: Before April everything is zero
    
    

    <Please see attached file for image>

    

Expected Result: All costs are rolled up and totals in the Hierarchy - Basic View match to the Hierarchy - Detail View
Actual Result: Some costs are not rolled up and totals do not match to the Hierarchy Basic View

Cause:

Caused by CLRT-60889 

Resolution:

Resolved in CA Clarity PPM 13.1.0

Workaround:
None.

 

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: