Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Workforce Profiles - Person Profile Real Time
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.
Answers
-
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
0 -
Thank you so much @Raghavendra Raghunath-Oracle. it works for me.
0
