Workforce Profiles - Person Profile Real Time

Saher

Hi everyone,

I need some assistance.

I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person's profile page, e.g. Language, skills, career preference, etc. It creates multiple rows and sections for one employee in my report, Which also creates an issue in filtering the desired result. I want to pull all records in one row without any null values. 

If anyone can help me with this issue, I would highly appreciate it.

Thank you.

Raghavendra Raghunath-Oracle

Hi @User_notn These are separate records hence appears that way. For example: If there are 3 languages and 2 competencies associated with a worker then it will display 5 rows. The closest that you can achieve is using a pivot view. Recreate the analysis using the attached xml

Raghu

Imp Note: Please post your ask on OTBI in the following path

Categories -> Reporting and Analytics -> Reporting and Analytics for HCM

profile pivot.txt

Saher

Thank you so much @Raghavendra Raghunath-Oracle. it works for me.