You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Combine Multiple Rows

edited Jun 21, 2017 3:55PM in Reporting and Analytics for HCM 6 comments

Summary

How do I combine multiple rows for a person into one row?

Content

We have a report that pulls in our terminations for the day.  There are some employees that are showing up with a Person Type = Dependent and Person Type = Ex-employee, so they have two rows.  Is there a formula I can use to combine into one?  I tried using this formula (from my OBIEE report writing library) and it is not working.  Thoughts?

LEFT(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),"Workforce Management - Person Real Time"."Person Type"."Person Type",', '), CHAR_LENGTH(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),"Workforce Management - Person Real Time"."Person Type"."Person Type",', ')) -2)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!