Not a single-group group error in Oracle

building semantic layer
1

Kevin Scoggins kscoggins@wciconsulting.com, Dani D Rubinoff drubinoff@wciconsulting.com

We were creating an object in Designer (Bo v 5.0.1, Oracle 8.0) using a decode function:

sum(decode(Category, ‘Co2’, Amount/2000, Amount)

When we clicked on OK, we received the following error message:

‘not a single-group group function’ when parsing.

Can anyone tell me what this error message means and what is causing it?

Thanks,

Michael Malone
Senior Consultant
WCI Consulting

Listserv Archives (BOB member since 2002-06-25)

2

In a message dated 00-03-04 12:48:45 EST, you write:

sum(decode(Category, ‘Co2’, Amount/2000, Amount)

When we clicked on OK, we received the following error message:

‘not a single-group group function’ when parsing.

Can anyone tell me what this error message means and what is causing it?

If you are creating the object exactly as shown, you are missing the final right parenthesis. Sometimes that can cause misleading error messages.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)