Dears,

we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section.

To do so we are crossing "Workforce Performance - Performance Task Status Real Time" and "Workforce Performance - Performance Rating Real Time" subject areas and we are pulling following info:

• Worker: Person Number, Name
• Performance Document:
  • Document Status
  • Task Name
  • Task Status Name
  • Role
  • Rating Level
  • Rating Description

As long as we pull Task Name info and Rating info it's working fine, but when we add Document Section info OTBI provides no more data:

If we were to delete "Role" filters, OTBI provides data but "Section Name" column is blank.

Any suggestion on how to proceed?

Thanks in advance

Domenico