Hello All!
I am attempting to make a report that has to change column values into a single row value. I am on 11g Release 1 (11.1.1)
(ex:
Name_______Certification____
John Smith Certification 1
John Smith Certification 2
John Smith Certification 3
John Smith Certification 4
)
Instead I need:
Name_______Certification____
John Smith Certification 1, Certification 2, Certification 3, Certification 4.
I've seen many posts about using the evaluate function but that is not available due to security restrictions with the NQSconfig file.
Does anyone know other alternatives to produce the above result in an OBIEE analysis.