ETC for Non-Labor Resources is 0 in Data Warehouse/ Jaspersoft Reports

Products

• Clarity PPM SaaS

Issue/Introduction

I don't see ETC for non-labor resources in Data Warehouse/Reporting, only labor resources are shown, what else should I do to get those displayed? 

Resolution

Any non-labor ETC or EAC is reported by choosing the ETC Cost or EAC Cost. There are no ETC Hours for Material, or Expense, only Cost. Equipment and Labor have ETC and EAC hours as well as cost

To make sure non-Labor Expenses and Material get to DWH as non-zero values, please ensure you always do the following:

1. Run the Rate Matrix Extraction 

2. Run on the project 'Update Cost Totals'. This will populate the cost fields on the Assignment.

3. Now run Data Warehouse - Full and check your data, and the resources should be included