The universe does not allow using a complex expression in a GROUP BY statement. You cannot run this query. (IES 00010)

[Former Member]

Hi All,

We have converted UNV version of the universe to UNX version. When try to map the reports to UNX version we are getting the 'the universe does not allow using a complex expression in a GROUP BY statement. You cannot run this query. (IES 00010)' error. When checked the logic for the objects in IDT then observed one case statement is causing the issue. When we use this statement with any other measure we are getting issue.

(case when (security.category='Default' and h_fact.short='L') then (security.type||'-Sell Protection')    when (security.category='Default' and h_fact.short='S') then (security.type||'-Buy Protection') when substring((security.type),1,19) = 'Notes' then substring((security.type),1,19) else security.type end )

Thanks

ls

[Former Member]

Is that meant to be Oracle syntax or IDT syntax?

[Former Member]

It uses Postgre SQL syntax

[Former Member]

Does the SQL work in a PostreSQL query tool?