Slice Table ODF_SL_ETCCOST Not Populating With Data

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The table ODF_SL_ETCCOST does not contain any data for ETC Cost from assignments.

Where and how can this date be found?

Resolution

In order to populate the ODF_SL_ETCCOST (table of ETC Cost on assignments), ensure the following are fulfilled:

1. The rate matrix must exist on the project.
2. The rate matrix must contain a matching rate.
3. Resources on the team/assignment need to be financially-enabled
4. The following jobs need to be ran in the following order:
a. Rate Matrix Extraction with correct options
b. Time Slicing job
c. Project > Team > Action > Update Cost Totals
or Update Earned Value and Cost Totals with selected projects.

The following example queries can be ran to validate data exists:

--1
SELECT 
id, request_name, is_dwh_request, IS_SYNCHRONOUS, table_name
FROM PRJ_BLB_SLICEREQUESTS
WHERE 
(
request_name IN 
('assignment::etccost_curve::dwh_month',
'assignment::etccost_curve::dwh_week',
'assignment::etccost_curve::dwh_fiscal')
) OR table_name = 'ODF_SL_ETCCOST'

Result:
5005001    assignment::etccost_curve::default    ODF_SL_ETCCOST
1000008    assignment::etccost_curve::dwh_month    PRJ_BLB_SLICES
1000023    assignment::etccost_curve::dwh_week    PRJ_BLB_SLICES
1000041    assignment::etccost_curve::dwh_fiscal    PRJ_FISCAL_BLB_SLICES

--2
SELECT * FROM PRJ_BLB_SLICES
WHERE slice_request_id IN (SELECT id FROM PRJ_BLB_SLICEREQUESTS WHERE id IN (1000008, 1000023, 1000041))

--3
select * from PRJ_EV_HISTORY