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 can we add multiple columns in an OTBI report for project team member roles

Received Response


We are building an OTBI report using Projects subject areas. In this report we need to show project wise details of team members assigned to that project in multiple rows. For this, we want to have separate column for each project role, accordingly person assigned to the project with that respective role will get displayed in each row, resulting in one line per project.

However, in project subject area, we have a seeded field for Project Manager role and for rest of the role we have a generic field - Project Role & Person. So if we include these fields in OTBI report, it results in multiple lines per project if there are more than one team members assigned to the project.

Howdy, Stranger!

Log In

To view full details, sign in.


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