Multivalue lookup is blank when using Group By in MUX Reporting

Products

• Clarity PPM SaaS

Issue/Introduction

Multivalue lookup is blank when using Group By in MUX Reporting

Steps to Reproduce: 

1. Create a static lookup
2. On the Issue object create a MVL attribute with the static lookup
3. Enable for API
4. In MUX populate values for this attribute on a few projects
5. Run the LDWH job
6. Go to Reporting>>Data Providers
7. Select New Data Provider
8. Objects select Investments & Issue
9. Publish
10. Go to Report Designer
11. Click New Report
12. Layout Format = Responsive
13. Select your Data Provider
14. Add a table widget
15. Add columns Investment Name, Issue Name, ID
16. Group By Issue Name

Expected Results: It will group by Issue Name and you still see the MVL attribute values

Actual Results: It will group by Issue name but the MVL attribute values are blank

Environment

Clarity 16.4.1+

Cause

DE204789

Resolution

This is a product limitation.

Workaround - 

Turn off "Auto Expand Groups" under Table Properties>>Format.  MVL values display correctly without it.