Phones and emails make duplication rows — 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

Phones and emails make duplication rows

edited Feb 22, 2018 9:22AM in Reporting and Analytics for HCM 9 comments

Summary

I'm trying to add columns for emails and phones but instead of one line it's duplicating it

Content

Hi,

I created an analysis in OTBI that shows employees phones and emails. So I created separate field for each phone type and email.

For example, for the Home mobile phone I used this formula - 

CASE WHEN "Workforce Management - Person Real Time"."Person Phones"."Phone Type Code" = 'HM' THEN "Workforce Management - Person Real Time"."Person Phones"."Area Code"|| '-' ||"Workforce Management - Person Real Time"."Person Phones"."Phone Number" END

For Work mobile phone - 

CASE WHEN "Workforce Management - Person Real Time"."Person Phones"."Phone Type Code" = 'WM'  THEN "Workforce Management - Person Real Time"."Person Phones"."Area Code"|| '-' ||"Workforce Management - Person Real Time"."Person Phones"."Phone Number" END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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