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