The datamart tables are returning 2 different rates
Article ID: 125108
Clarity PPM SaaSClarity PPM On Premise
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.