Why do you always have to select distinct on add data aggregates?

[#1]

Seems to me if you group by all the dimensions and aggregate the measures you shouldn't have dupes?

[#2 · Accepted solution]

Yup! Glen you are right .. We always use distinct to avoid duplicates while grouping.