The datamart tables are returning 2 different rates

Article Id: 125108

Status: Published

Updated On: 24-05-2019 15:22

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

Client is running billing report by extracting data from datamart table 'nbi_project_res_task_facts'. They get different cost-rates for the same combination of 'Project, Resource, Team, Task, Fact Date, OBS_UNIT_ID (1-5), Resource Type, Role_ID, charge_code. Even after successful execution of datamart extraction and datamart rollup jobs; the datamart tables are still showing different rates for combination. Its difficult to determine the correct rate by information available in data-mart tables.

Cause:

Defect DE41901

Environment:

CA PPM 15.4.1

Resolution:

Fix in CA PPM 15.4.1 patch 3.