Universe Object error - not a single group function

[Former Member]

Hi,

While trying to create a object in Universe I am getting a group-by function error when i try to validate the object. How do I avoid this error?

* Universe object is like a SQL SELECT statement. So I don't see any scope to add Group-by statement there.

Did anyone face this issue before, if so how did u rectify it?

Please guide me here.

FYI, I am using BO 4.1 SP9

Thanks & Regards.

Naveen.

[amitrathi239 · Accepted solution]

This is happening as you have used max and sum function in the case statement.try to create derived table for max and sum part and group these in the derived table and later use in the case stat