Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Fetch multiple nationalities/citizenships in a single row on OTBI
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?
Answers
-
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
0 -
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.
0 -
Hi @Vibha Pandey - Oracle
Did you manage to get the multiple nationalities in a single row? I am having a similar use case and not able to achieve the desired output.0 -
Welcome to the Oracle Analytics Community!
As it is an year old post (and if you are not able to receive any answer), I would recommend you to raise a new question with all relevant details like issue details, screenshot (without sensitive data) etc. so that someone can able to help you.
Thank you.
0
