ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
DWH cannot find cost on allocations
Article ID: 219084
Updated On:
Products
Clarity PPM On Premise
Clarity PPM SaaS
Issue/Introduction
We are trying to use allocation hours and allocation cost in our reports. Where can we find this information in DWH?
Environment
Version: 15.9.2
Resolution
Following are the tables that hold these details.
dwh_inv_team_period_facts
dwh_inv_team_summary_facts
Each of the above tables have the following columns in them.
alloc_hours
alloc_cost
Please note that value against alloc_cost will be 0 unless "Update Cost Totals" is used in the Team tab, or if the "Update Earned Value and Cost Totals" job is not scheduled in the system. Documentation regarding this job is below.
Feedback
Yes
No
Powered by
