Mismatch of "Baseline Usage" between PPM and DWH

book

Article ID: 5338

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

The "Baseline Usage" values in PPM and DWH do not match under certain circumstances.

Steps to Reproduce:

1. Create a Project

2. Allocate a team member

3. Assign this resource to a task, say Task 0

4. Assign this same resource to another task, say Task 1

5. Create a baseline

6. Lets say the “Baseline Usage” shown at this point is 250 (under the “Team” tab)

7. Running the Load Data Warehouse job will put Baseline Usage = 250, in the DWH

8. Go ahead and delete the assignment made on Task 1 at step 4

9. The PPM UI (under “Team” tab) will still report Baseline Usage at 250

10. But on running the Load Data Warehouse job, the Baseline Usage available in the DWH will be, say 150

11. This results in users seeing different values in the PPM UI (under “Team” tab) and in the DWH.

Cause

Caused by DE31586


Environment

Release: All PPM Releases


Component: CA PPM JASPERSOFT

Resolution

This happens because Load Data Warehouse job picks up Baseline Usage by filtering for “PRJ_BASELINE_DETAILS.OBJECT_TYPE” = “TEAM”, but the Load Data Warehouse gets the Baseline Usage data by filtering for “PRJ_BASELINE_DETAILS.OBJECT_TYPE” = “ASSIGNMENT”