Transpose Columns in OBIEE
DustinCAug 21 2008 — edited Sep 19 2008I have a table with 3 columns of different amounts named (Commission Amount, Batch Amount, Order Entry Amount). Is there a way in OBIEE to transpose these columns so they appear as 3 different rows. In other words when transposed it would create 3 rows with 2 columns - The column header would become the value in the first column and the amount would become the value in the second column.
For those who have a BO background this was available there, I was just wondering if this feature/funcitonality existed in OBIEE.