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

Fetch multiple nationalities/citizenships in a single row on OTBI

Received Response
21
Views
2
Comments
Vibha Pandey - Oracle
Vibha Pandey - Oracle Rank 3 - Community Apprentice
in Oracle Fusion HCM Analytics

I have a requirement where I need all the nationalities of a person in a single row. Ideally when we fetch the citizenship we get multiple rows. We have tried RCOUNT and PIVOTTING Results but no luck. Has anyone achieved this already?

image.png image.png
Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi @Vibha Pandey - Oracle ,

    I have had a similar question in the past, but the problem was that all Nationalities were displayed but only the current one was desired. This is explained in a little more detail in Doc ID 3021065.1.

    Diversity Analysis includes 'Country Of Citizenship' and it will show all citizenships (nationalities) by default. If you want to filter out expired citizenships, you can use the filter: Citizenship Status Code = E (expired) (CITIZENSHIP_STATUS).

    Hope that helps.

    Regards,

    John

  • Vibha Pandey - Oracle
    Vibha Pandey - Oracle Rank 3 - Community Apprentice

    Thanks John!

    My client has a population where dual citizenship is common. I need both of them on the report and in one single row. Something like Nationality1, Nationality2.