Forum Stats

  • 3,874,758 Users
  • 2,266,769 Discussions
  • 7,911,962 Comments

Discussions

Columns into Single Row Values

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.

Tagged:

Answers