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?
Release : 15.9.1
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_ACTUAL_COST_VAR - REMAINING BUDGET
Calculate Remaining Budget:% BDGT_COST_VAR/BDGT_COST
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.