Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to get results on a single row. — Cloud Customer Connect
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

How to get results on a single row.

Accepted answer
18
Views
4
Comments
edited May 4, 2021 3:25PM in Reporting and Analytics Taleo Enterprise 4 comments

Content

i am using the OBI tool to generate a report in the Admin section of Users and their respective coverage groups. I would like to have the results of the departments (if multiple) to be on one row separated by a comma. Right now it's displaying using the suppressed column. 

I'm new to using OBI so I'm not sure if this is possible or if I'll have to work it in excel.

For instance it has this 

 

John Smith    Dept1

                      Dept2

                      Dept3.

 

I would like it as 

John Smith      Dept1, Dept2, Dept3. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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