BI Publisher (MOSC)

MOSC Banner

Can't subgroup SQL statement using a WITH statement.

edited Jun 25, 2015 10:09AM in BI Publisher (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center