Adhoc Views duplicates data when multiple DWH languages are configured

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When creating an adhoc view based on default Project management Domain, the Assignment costs / actuals are being aggregated for every DWH language that is set. 

STEPS TO REPRODUCE:

1. Set the Data Warehouse language to: English, French, Portuguese
   
2. Run the full Load DWH job.
3. On the Project Management Domain, create an ad hoc view in a table format
   with the following columns:
   -Project Name
   -Task Name
   -Assignment Name
   -Week 
   -Week Start
   -Measure: Assignment ETC Hours or Assignment Actual Hours
4. Filter on each of the attributes

Expected Results: A filter should exist on for the language.

Actual Results: Without a language filter, the values are summed/aggregated 
due to the record fulfilling each unique DWH language.

Workaround: None 

 

In the example above, there should only be one line per week, representing the selected language of the user running the adhoc report.

Environment

Clarity Release : 15.9.1, 15.9.2

 

Cause

This is happening because some joins to the common period table are missing the language code as part of the join condition. Without filtering by language results are doubled, tripled, etc. Fix was to Include the join condition for the tables where it is missing. 

Affected domains in advanced reporting:

-  Application Management, Idea Management and Investment Management domains:
    - Team per facts - Fiscal, Monthly and Weekly
-  Resource Management domain 
    - Team per facts - Fiscal, Monthly and Weekly
    - Assignment per facts - Fiscal, Monthly and Weekly
-  Project Management domain 
    - Team per facts - Fiscal, Monthly and Weekly
    - Task per facts - Fiscal, Monthly and Weekly
    - Assignment per facts - Fiscal, Monthly and Weekly

- Financial Management and Time Management domains did not require any changes

Resolution

Resolved in 15.9.3 as DE60959