Skip to Content
0
Former Member
Feb 13, 2014 at 09:09 AM

how to use GROUP BY Function in BO(4) Universe

2728 Views

Hi,

I am facing the below error while using the object PRQ_DESC in webi report.


Please note i dont see any issues while generate the output ONLY FOR this object. If i combined with additional objects in a same report, i am getting this error.


"An expression starting with &quot;PRQ_DESC&quot; specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803 . (IES 10901) (WIS 10901) in webi report - Google Search">An expression starting with "PRQ_DESC" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803 . (IES 10901) (WIS 10901) in webi report - Google Search</a>"

Existing Code in Universe : (PARSING OK)

DB2ADMIN.FT_PRA.PRQ_DESC

I updated to add GROUP BY as below in Universe: (PARSING FAIL with error expected token may include)

case(DB2ADMIN.FT_PRA.PRQ_DESC GROUP BY DB2ADMIN.FT_PRA.PRQ_DESC).

Can anyone plz help me out on this? Plez direct me if my understanding is wrong in using GROUP BY Function.