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

book

Article ID: 219084

calendar_today

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.