ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Project Cost Variance % /Schedule Variance % Not Matching DWH_INV_SUMMARY_FACTS

book

Article ID: 239644

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Project Cost Variance % /Schedule Variance % not matching the DWH table DWH_INV_SUMMARY_FACTS columns
DWH_INV_TASK_RU_SUM_FACTS_EV_COST_VAR_PCT
DWH_INV_TASK_RU_SUM_FACTS_EV_COST_VAR
DWH_INV_TASK_RU_SUM_FACTS_EV_SCHEDULE_VAR
DWH_INV_TASK_RU_SUM_FACTS_EV_SCHEDULE_PCT

STEPS TO REPRODUCE:
1. Configure the following fields to the Project List

Cost Variance %
Schedule Variance %

 

2. Review an example project.

 

3. Run the Load DWH job.

4. Compare the the example fields to the fields in the DWH table with query produced.

 

Actual: The values do not match in the DWH table.

Expected: The values should match since they are an extract of Clarity

Environment

Release : 15.9.3, 16.0.1

 

Resolution

This is reported as DE64835 and after review from Engineering Team review, has been converted to a user story as it requires significant changes and testing.



Workaround is to use adhoc view/report using Project Management domain.

Additional Information

Use query produced:

select * from ( select "DWH_INV_INVESTMENT"."INVESTMENT_ID" as "DWH_INV_INVESTMENT_INVESTMENT_ID", 
"DWH_INV_INVESTMENT"."INVESTMENT_NAME" as "DWH_INV_INVESTMENT_INVESTMENT_NAME", 
"DWH_INV_TASK_RU_SUM_FACTS_V"."EV_COST_VAR" as "DWH_INV_TASK_RU_SUM_FACTS_V_EV_COST_VAR", 
"DWH_INV_TASK_RU_SUM_FACTS_V"."EV_COST_VAR_PCT" as "DWH_INV_TASK_RU_SUM_FACTS_V_EV_COST_VAR_PCT", 
"DWH_INV_TASK_RU_SUM_FACTS_V"."EV_SCHEDULE_VAR" as "DWH_INV_TASK_RU_SUM_FACTS_V_EV_SCHEDULE_VAR", 
"DWH_INV_TASK"."TASK_ID" as "DWH_INV_TASK_TASK_ID", 
"DWH_INV_TASK"."TASK_NAME" as "DWH_INV_TASK_TASK_NAME"
from "PPM_DWH"."DWH_INV_INVESTMENT" "DWH_INV_INVESTMENT"
inner join "PPM_DWH"."DWH_INV_TASK" "DWH_INV_TASK" on ("DWH_INV_INVESTMENT"."INVESTMENT_KEY" = "DWH_INV_TASK"."INVESTMENT_KEY")
inner join "PPM_DWH"."DWH_INV_TASK_RU_SUM_FACTS_V" "DWH_INV_TASK_RU_SUM_FACTS_V" on ("DWH_INV_TASK"."TASK_KEY" = "DWH_INV_TASK_RU_SUM_FACTS_V"."TASK_KEY")
inner join "PPM_DWH"."DWH_INV_SECURITY_V" "DWH_INV_SECURITY_V" on ("DWH_INV_INVESTMENT"."INVESTMENT_KEY" = "DWH_INV_SECURITY_V"."INVESTMENT_KEY")
where ((("DWH_INV_SECURITY_V"."USER_UID" = 'admin') and "DWH_INV_INVESTMENT"."INVESTMENT_TYPE_KEY" = 'project') and "DWH_INV_INVESTMENT"."INVESTMENT_TYPE_KEY" = 'project'
--and "DWH_INV_TASK_RU_SUM_FACTS_V"."EV_COST_VAR" < 0
and "DWH_INV_INVESTMENT"."INVESTMENT_KEY" = 'PR0021123'
)
order by DWH_INV_INVESTMENT.INVESTMENT_ID
 ) where ROWNUM <= 1000 

Attachments