What's new in Customer Journeys?

Connect and learn more! ×
Comparing columns from two different Analysis areas. — Cloud Customer Connect
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

Comparing columns from two different Analysis areas.

Accepted answer
36
Views
14
Comments
edited Dec 30, 2020 7:48PM in Reporting and Analytics for HCM 14 comments

Summary

Comparing columns from two different Analysis areas.

Content

I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am using the "Workforce Profiles - Model Profile Real Time" and "Workforce Management - Grade Rate Real Time" areas. A job will have a valid grade of M25-M25 and I want to grab the associated grade info code that equals LEFT("Valid Grade",3), i.e. M25. When I create a filter with a SQL expression

LEFT("Workforce Profiles - Model Profile Real Time"."Job"."Valid Grades", 3) = LEFT("Workforce Management - Grade Rate Real Time"."Grade"."Grade Code",3)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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