Group By not forming in the report SQL

[Former Member]

Hi,

I am trying to use the combination of Measure and Dimension objects in my WebI report. I am not getting the Group By clause formed in the report SQL and results in data duplication.

I use DECODE function in my measure object syntax.

Kindly help me on this issue.

Many Thanks,

Mohan

[Former Member · Accepted solution]

Hi Mohan,

Do you get Group By generated for other queries with simple measures with aggregate functions such as Sum, Max?

If its a problem in generating Group By across all queries then you need to assign the universe parameter  "GROUP BY" to Yes

If the issue is specific to only this query, the please check if you have used any aggregate function in the measure along with Decode function? remember decode is not a group by expression.

Thanks

Mallik

[former_member189638 · Accepted solution]

Make sure that for the measures in the Universe, you have select SUM

Also in the WebI report, select the Table and do a right click. Select Format Table. In the General tab, uncheck the option Avoid Duplicate Row Aggregation.