Can't subgroup SQL statement using a WITH statement.
HI
I am trying to create a datamodel using a WITH statement, and want to make parts of the selection into subgroups, but I am not allowed.
How come? Is it just a thing that BI Publisher don't support? If so, is it coming?
A example could be using the following SQL:
with myStm as (select 'hej', current_date from dual)
select *
from myStm;
Here it is not possible to use Group by, but with a similar sql like:
select 'hej', current_date from dual;
I am able to select group by:
Best regards Jonas Jensen