@VinothKumarD  are your all 150 partners exclusive? Can we combine them into groups? https://experienceleague.adobe.com/docs/analytics/analyze/analysis-workspace/curate-share/share-projects.html?lang=enhttps://experienceleague.adobe.com/docs/analytics/analyze/analysis-workspace/curate-share/shareabl...

@NitroHazeDev i raised an Adobe Support ticket last month for this log trace and they confirmed that its still not fixed in 6.5.11.  They proposed we should live with workaround as of now. Try raising adobe Support ticket for omni search feature.   

@aleber  Solution of your problem statement has been listed in below blog :  https://experienceleaguecommunities.adobe.com/t5/adobe-antics-questions/devices-report-not-showing-breakdown-of-device-model-for-iphone/td-p/296384

@evan9 _ I think you might need to contact adobe support to mask IP information  "Adobe customer can choose to remove the IP"experienceleague.adobe.com/docs/analytics/technotes/privacy-overview.html?lang=en 

@VinothKumarD  There is OOTB citiesdimension to extract city information https://experienceleague.adobe.com/docs/analytics/components/dimensions/cities.html?lang=en

Are you getting any exceptions in logs ( number format exception )  while processing this data - 

@NitroHazeDev Yup this is a known bug , You can solve it through workaround suggested.https://helpx.adobe.com/au/experience-manager/kb/Unclosed-ResourceResolver-warnng-at-com-day-cq-search-impl-builder-QueryBuilderImpl.html

Can you please expand the column of the csv and check once?

Can you please elaborate more on your use case ?  

https://medium.com/@vsr061/create-custom-aem-menu-tools-with-granite-ui-shell-53c56e435f8aTry referring above doc