STEPS TO REPRODUCE:
1. Login to Clarity.
2. Navigate to Administration -> Objects -> Status Report Object -> Overal Status Attribute.
3. Click on Build Calculated Attribute and use expression Max(cop_cost_eft_status,cop_schedule_status,cop_scope_status).
4. Navigate to Administration -> Objects -> Project -> Create new Attribute -> Data Type Aggregated -> Expression AGG_Max(cop_prj_statusrpt.cop_overall_status) and Filter ( Status Report Latest = 1 ).
5. Include this attribute in DWH.
6. Run the Full DWH Load
Expected Results :- Job takes comparatively normal time compared to previous runs
Actual Results :- Job takes significantly more time to complete.
Release : Clarity SaaS 16.0.0, PostgreSQL
Component : CLARITY DATA WAREHOUSE
This is caused by Defect DE64035
This is under review by Engineering team for future consideration. There is not yet an ETA on when this will be addressed