Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to add the logic in OTBI Report

Received Response
12
Views
3
Comments
User_WF2X0
User_WF2X0 Rank 0 - Community Observer
in Oracle Fusion HCM Analytics

Please apply logic to the "Ethnicity" field: If multiple selections include Hispanic, only populate Hispanic in the ethnicity field, if multiple selections do not include Hispanic, populate Two or More in the ethnicity field.

 

Answers

  • gclampitt
    gclampitt Rank 6 - Analytics Lead

    Have you tried anything ? Looked at the Case statement?

    case when Ethnicity like '%Hispanic%' then 'Hispanic' else Ethnicity end

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_WF2X0 - This community is specifically dedicated to FDI/FAW queries. For OTBI-related discussions, we have a dedicated community forum. Please use the following forum for OTBI-related queries in the future:
    OTBI Community Forum

    @John Hung-Oracle
    Could you kindly assist in moving this thread to the OTBI community?

    Thank you!

  • User_WF2X0
    User_WF2X0 Rank 0 - Community Observer

    CASE WHEN "Worker"."Employee Ethnicity" = 'I am Hispanic or Latino.' THEN 'Hispanic' ELSE 'Two or more races' END
    used this condition still it was pulling duplicates