The datamart tables are returning 2 different rates

book

Article ID: 125108

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL 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.