What table/query is used to pull in the Planned NPV total that is used in the Hierarchy Rollup page for a program?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

What table/query is used to pull in the Planned NPV total that is used in the Hierarchy Rollup page for a program to add to a custom portlet using a query?

Environment

Release : All Supported Releases

Component : CA PPM PORTFOLIO MANAGEMENT

Resolution

• Assistance with creating this query would be something that would require assistance from someone outside of Support, such as Services.
  • See Configuration section of the Clarity PPM Modification Policy documentation for more info on support of NSQL
• Another option would be to post the question in the Clarity PPM Communities to see if another customer has suggestions on how to create the correct query.

Additional Information

To submit an enhancement to create a portlet out of the box with this feature see KB: 18799