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
Release: All Clarity Releases
Component: CLARITY DATA WAREHOUSE
This was analyzed by Engineering through DE31586 and is working as designed.
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: