This discussion is archived
2 Replies Latest reply: Nov 13, 2012 2:07 PM by Voltaire RSS

Multiple column values as one row

963667 Newbie
Currently Being Moderated
I have a table in an OBIEE 11g report with column 1 = term (Fall 2011, Spring 2012, etc.). Column 2 can contain multiple values for campus names for each semester. I'm trying to create a report to output the following:

Fall 2011: Campus 1, Campus 2, Campus 3
Spring 2012: Campus 1, Campus 3, Campus 4

etc.

Can this be done in any available 11g view? I believe we're running 11.1.1.6.2.

Thanks,
Dottie

Edited by: 960664 on Nov 13, 2012 12:37 PM

Legend

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