1 Reply Latest reply: Nov 22, 2012 12:03 AM by 883915 RSS

    show suppressed data in table

    883915
      Hi, i have a relationship A <-- B and A<-- C

      so basically, 1 row from table A corresponding to multiple in table B as well as C. Row in table B and C has no relationship

      but as BI table turn out, if i put B column before C, row in table C will loop throw each B and vise versa.

      How can i show a suppressed data like
      rowA1 ---- B1.1, B1.2----- C1.1, C1.2
      rowA2 ---- B2.1, B2.2----- C2.1, C2.2

      and not

      rowA1 ---- row B1.1 ---- row C1.1
      ---- row B1.1 ---- row C1.2
      ---- row B1.2 ---- row C1.1 (repeated)
      ---- row B1.2 ---- row C1.2 (repeated)
      rowA2 ---- row B2.1 ---- row C2.1
      ---- row B2.1 ---- row C2.2
      ---- row B2.2 ---- row C2.1 (repeated)
      ---- row B2.2 ---- row C2.2 (repeated)

      i tried the suppress column in the column attribute (criteria tab) to no avail.....

      Pls tell me any changes in the repository or analysis that would do the trick
        • 1. Re: show suppressed data in table
          883915
          hi, i tried to follow

          http://biztricz.blogspot.com/2012/06/obiee-converting-rows-into-column.html

          but the problem is they can only group the column based on another column from the same table
          for example: column A, column B

          CAST ( EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (order by %3) , Table1."A" , ', ',Table1."B" ) AS CHARACTER ( 150 ))

          then it will work, given that multi row in column A corresponding to the same value in table B.

          while i try with

          CAST ( EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (order by %3) , Table1."A" , ', ',Table2."B" ) AS CHARACTER ( 150 ))

          it will return

          result of string concatenation is too long at OCI call OCIStmtFetch