OBIEE SQL and Listagg function
Summary
Need to display a list of degrees and certifications in a list for a reportContent
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
1