Skip to Content
0

Universe Object error - not a single group function

Oct 31, 2017 at 08:03 PM

32

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Oct 31, 2017 at 08:29 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded