Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EVALUATE_AGGR in OBIEE 12c

choracy69May 31 2019

Hi everyone,

I have problem with analysis in OBIEE 12c.

I created analysis with UNIONN ALL and it is working ok and it looks like:

And now I want see something like:

ID || NUMBER || ROLE

8462913 || II-2000-v7336 || INS, IND

8462913 || MI-2010-v635350 || IND

8462913 || POM-2018-t6262 || INS, IND

Thats mean I want aggregate Role wth group by ID, NUMBER

I think about something like that: EVALUATE_AGGR('LISTAGG(%1,%2) (ORDER BY %3 DESC)',saw_2,',',saw_2)

But I have error that thhe instruction SQL must have Group by clouse.

I try to convert formule to: EVALUATE_AGGR('LISTAGG(%1,%2) (GROUP BY %3)',saw_2,',',saw_2, saw0) but i still have the same error.

Can anyone help me with formule for listagg in evaluate_aggr?

Comments

2b520810-9296-4389-b67c-f22cddc81f53

I had find no plugin in 3.05  either.

and no plugin in 3.04

only EclipseJCDE 0.2 can be found at EclipseJCDE

but it just supports jcdk 2.2.2

FT-Oracle
Answer

Hi - the plug-in is now included again as part of the Java Card Development Kit 3.0.5u1 download at Java Card SDK Downloads..

Apologies for the inconvenience as it was temporarily unavailable.

Marked as Answer by DEADBEEF · Sep 27 2020
DEADBEEF

I've downloaded the JCDK and installed the plugin on Eclipse Neon 3. It works properly.

Thanks for your help !

1 - 3