Budget/Effort Remaining percentage of Projects in DWH?

Products

• Clarity PPM On Premise

Issue/Introduction

In new UX, project tile page, there are 2 number percentages: Budget Remaining and Effort Remaining. We would like to know if we can find those 2 fields in Data Warehouse table?

 

Environment

Release : 15.9.1

Component :

Resolution

Fields are available in the data warehouse but you may need to create calculated measures to get the results.

 

The fields in the data warehouse are:

Table: DWH_INV_SUMMARY_FACTS for 

BDGT_COST

BDGT_ACTUAL_COST_VAR - REMAINING BUDGET

Calculate Remaining Budget:%  BDGT_COST_VAR/BDGT_COST

 

EFFORT:

Calculate Remaining Effort%:  ETC_TOTAL_HOURS/EAC_TOTAL_HOURS

 

There are fields in the project management domain which also can be used to calculate the percentages.