You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OBIEE SQL and Listagg function

edited Jun 9, 2021 7:38PM in Reporting and Analytics for HCM 2 comments

Summary

Need to display a list of degrees and certifications in a list for a report

Content

Hi all,

I am trying to produce a list of certifications and degrees for each employee in one record (hopefully separated by a semi-colon)

I have the query built to show the employee number, name and education (I built a UNION query) and then based on that I was trying to use the Listagg function.

I have read that it is not available if my query was using OTBI tables/views but I am using the actual tables.

Am I able to use this function? If not, is there a way to produce the list using a different method

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!