Description
Cube rewriter rewrites query with distinct if only keys are projected and having specified. Instead it should promote group by with projected columns.
for eg.
cube select key1 from table having msr1 > 0
is being rewritten to "select distinct key1 from table having sum(msr1) > 0 " but it supposed to be rewritten to
"select key1 from table group by key1 having sum(msr1) > 0"