Skip to Content

Universe Object error - not a single group function

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 31, 2017 at 08:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded