How to limit the Global Search for different roles? For e.g. if there is a role for Australia, the user should only be able to view Australian data in the Global Search. It seems to be working for all the Business views except Global Search.

thanks for your question! You can use the sem_f_split function that allows using IN with the result of a split, like this :

FID_GeographyID in sem_f_split( case when :V_USER_ROLE like '%AP_dEM1_XDM_SEASK_DS%' then 'PH,TH,VN,KR,MY,SG'  when <yourotheruser_rolesconditions> end, ',')