2 Replies Latest reply: Nov 13, 2012 4:07 PM by Voltaire RSS

    Multiple column values as one row

    963667
      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