The "Baseline Usage" values in Clarity and the Data Warehouse (DWH) do not match under certain circumstances.
Expected Result: The Clarity UI (under the “Team” tab) reports the same baseline usage value of 250 as in DWH
Actual Result: The Baseline Usage available in the DWH has changed and is now 150
This was analyzed by Engineering through DE31586 and is working as designed.
Release: All Clarity Releases
Component: CLARITY DATA WAREHOUSE
The reason this is working as expected is that Clarity picks up Baseline Usage by filtering for “PRJ_BASELINE_DETAILS.OBJECT_TYPE” = “TEAM”, whereas the Load Data Warehouse gets the Baseline Usage data by filtering for “PRJ_BASELINE_DETAILS.OBJECT_TYPE” = “ASSIGNMENT”
The two columns of interest here, in the DWH are: