There was a requirement of aggregating multiple row values to one row. This is a requirement of summarizing the data which is easily achievable using SQL. However this article will provide you information on how to do it in OBIEE.
Here there are different employees in different department .
And you would want to see it as below.
For this you would have to use the EVALUATE Function.
EVALUATE_AGGR(‘LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)’,”Dim – Campaign “.”Employee_Name”,’,’,”Dim – Campaign “.”Employee_Name”)
The separator is ‘,’ which can be modified based on your requirement .