Skip to Main Content

Columns into Single Row Values

00791a16-2951-43dd-9afb-db8fed6712e9Oct 8 2018 — edited Oct 9 2018

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.

Comments