0 Replies Latest reply on May 31, 2019 8:02 AM by choracy69

    EVALUATE_AGGR in OBIEE 12c

    choracy69

      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?