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
Can this be done in any available 11g view? I believe we're running 184.108.40.206.2.
Edited by: 960664 on Nov 13, 2012 12:37 PM
Try this and let me know.
Evaluate_Aggr('XMLAGG(XMLELEMENT(%1,%2) order by %3).extract(%4)',col1,col2||'; ',col2,'//text()')
you might need to change the col1 col2 to match your db columns.
Note: Your Database should be 11g to work this out.
Edited by: Voltaire on Nov 13, 2012 2:06 PM