apps-infra

    Forum Stats

  • 3,874,042 Users
  • 2,266,667 Discussions
  • 7,911,702 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

apps-infra