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:
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.
Clarity Release : 15.9.1, 15.9.2
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
Resolved in 15.9.3 as DE60959