Hi @Nathan CCC that limit by option will not work for me as I need to add more conditions here. Regards Ankur

Hi @Varun Malhotra-Support-Oracle , I have followed step 8 and 9 as well but I was still able to see the folders. Do we need to remove jobs roles from employee profile ?

Hi @User_NGYZL May I know where is the HTML Markup Privilege setting to store custom settings. Regards Ankur

Hi @Dimple-Nagesh-Support-Oracle , we also need to same stuff. I have removed duty roles directly from CUSTOM_BI_WEBCAT_REPORTING_DUTY role. Should we need to take copy first and attach to job role. as per the documentation we can directly remove the duty roles from this one and ran the process. I have done same but few…

Thanks @gclampitt for your back and forth reply on this.

Hi @gclampitt , Not sure . I have removed all the cache but still it is showing to me. is there any process I need to run. Although, from role perspective I have full access i.e. integration specialist and view all data access but as you said if we removed from manage privilege section it should not appear in search list.…

Hi @gclampitt , If I have BI administrator access, will I have still access to see these subject areas as I have denied the access for BI author role but BI administrator role was also not there so I thought it should not be visible with admin too. Regards Ankur

Hi @gclampitt , this is exactly I have done but when we create the analysis then we first search subject area and there only I am still able to see the subject area. Although, when we click on subject area then it says you don't have permission to access the subject area as shown in following screenshot: Requirement is to…

Hi @gclampitt , I tried to use manage privilege option but it is not hiding from search list. if we click on that subject area then it shows you don't have access. Our requirement is to completely remove from this search list as shown in screenshot. Any suggestions on this? Regards Ankur

Thanks @gclampitt for your quick help on this.

Thank you not sure why it don't pop while searching. but can we hide the catalog folders too ?

Hi @Bhaskar Konar , Thanks . I have used my default value only. SELECT "Department"."Department Name" FROM "Workforce Management - Worker Assignment Real Time" where "- Hierarchy"."Level 1 Department" IN (@{R1}['@']{'ΔΙΟΙΚΗΣΗ [1]'}) and "Department"."PER_ORGANIZATION_UNIT_DFF_LEVEL_NR_" >1 I need to find out direct and…

Hi @Bhaskar Konar , Thanks for providing the syntax. Could you please let me know how it works. It is working for multi select but default value is not working . I am still unable to understand this weird syntax. Regards Ankur

Hi @Bakr Elkassas , You can control the security via duty role. You need to specifically remove the duty role of that subject area from user privilege. You can refer the duty role details against subject areas from following link: Regards Ankur

I have done the needful. Thank @ashish.f.singh-Oracle

Hi @Sumanth V -Oracle , I was not able to see the logs when I checked manage session against « FA-URL>/Analytics where as I was able to see the logs for FDI - OAX analytics. Regarding roles , if we have provisioned the FAW in the same domain where FA application exists then roles and permissions are in sync. I am just…

Hi @Sumanth V -Oracle /@ashish.f.singh-Oracle , I am confused here. I was trying to execute the query in OTBI with my login as I was logged in FAW with my user. AS source data is validated by the user which I passed under source credential tab so I tried to check with that user but that user is only have BI Impersonate…

Hi @Sumanth V -Oracle /@ashish.f.singh-Oracle Thanks for your input. Issue has been resolved. My user was referencing to this table then I removed myself from some data role and filter is working now. Regards Ankur

Hi @Sumanth V -Oracle , Thanks for your reply. I have checked the OTBI report query and there is no additional filters are there. Here is the query I got it from log: SELECT "Facts - Workforce Headcount"."Current Headcount" FROM "HCM - Workforce Core" WHERE "Employment Information"."System Person Type Code" IN ('EMP') AND…

HI @Sumanth V -Oracle , I was trying to query 'SEC_SECURE_BY_OBJ_MEMBER_USER record from OAX_USER schema but it is showing table or view doesn't exist. is there any schemaI need to add before table name. Regards Ankur