Performance OTBI to extract Task Status, Section Names, Rating Levels

Domenico P.

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

XML.txt

SQL_issued.txt

Lauren Kinkler

@Domenico P. Please find OTBI Analysis for different Subject Area Workforce Performance - Performance Rating Real Time which yields results.

User posted Analysis XML and SQL here, in comments: https://community.oracle.com/customerconnect/discussion/729825/report-out-of-performance-management-for-participant-feedback#latest

Domenico P.

Hi @Lauren Kinkler

Analysis is working fine when pulling roles, sections and section ratings.

It's now working when tasks and tasks status are added.

Domenico