Negative values in PPM are being shown as zero value when migrated to the CA DW

Products

• Clarity PPM SaaS

Issue/Introduction

The negative values that are entered into Time Varying fields in Clarity are being shown as zero value when migrated to the Data Warehouse, while the positive values remain the same.

Resolution

This is caused by a known Clarity defect: 

DE36523 Creating more than one TSV attribute in any Object results in negative values of these TSVs being put to DWH as zeros

STEPS TO REPRODUCE:

Project object is being taken as an example here. The STR holds good for other objects as well.

1. Navigate to the Project object

2. Create two TSV attributes

3. Populate negative values against these two TSV attributes

4. Open the PPM Database, and run the following query:select *from dwh_fct_project_v

5. Run Load Data warehouse job, and run the following query in the DWH Schema:select *from dwh_project_facts

Expected Results: The negative values mentioned in step 3, should be visible in steps 4 and 5.

Actual Results: The negative values have been replaced by zero in both steps 4 and 5.

Fixed in 15.4 and higher.

 

There is no known workaround, our suggestion is to schedule an upgrade to get this resolved