This discussion is archived
1 Reply Latest reply: Nov 21, 2012 10:03 PM by 883915 RSS

show suppressed data in table

883915 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points