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

SQL to take out alternating rows for Risk and Impact?

Accepted answer
51
Views
10
Comments
in Reporting and Analytics for HCM 10 comments

Summary:

Subject Area: Workforce Profiles - Person Profile Real Time

Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss"

Content (required):

Hi All,

When using the Workforce Profiles - Person Profile Real Time subject area, we are pulling in columns "- Risk of Loss"."Impact of Loss" and "- Risk of Loss"."Risk of Loss". Impact and Risk data pulls from separate areas of the system and as a result - the data will not appear all on the same row. One row of data would exist for Risk, a second row existing for Impact.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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