Universe Dimension is not "Grouping" in SQL

[Former Member]

I have a universe where a certain Dimension is not grouping when inserted into a query and an error is thrown when I try to run this query. i.e. When I look at the SQL in the query panel, it is not grouping. This is shown in the screenshot below.

Weirdly, all the other dimensions in the universe group fine.

Is there a specific setting to force this object to group?

Thanks

[Former Member · Accepted solution]

It turns out that you need the fully qualified column name:

1. i.e. patterndata.pattername and not patternname.

This fixed it.