MicroStrategy ONE
GROUP BY Non-ID Attribute
The GROUP BY Non-ID Attribute property controls whether non-ID attribute forms, such as descriptions, are used in the GROUP BY clause. If you do not want non-ID columns in the GROUP BY, you can use a MAX function when the column is selected so that it is not used in the GROUP BY.
For an example, see the System Administration Guide.