workbook filter is not working in OAC workbook

Ankur Jain--Oracle

Hi Team,

I have enabled the pipelines in FAW/FDI but when we tried to open a workbook then data is appearing but workbook filter is not showing any value. Please let me know what data role or any other role could impact this behaviour.

Regards,

Ankur

Ashish-Oracle

@Ankur Jain--Oracle SEC_SECURE_BY_OBJ_MEMBER_USER is an internal table and not exposed to OAX_USER schema. This table comes into picture when some data level security is there in place for the user logging in.

As requested by @Sumanth V -Oracle please open the same workbook again, enable the developer mode and check any one report's Execution Log. There should not be any references to this table. That would confirm no data level security issue is there in this case.

Ashish-Oracle

Hi @Ankur Jain--Oracle Did you verify if the underlying database table DW_BUSINESS_UNIT_D_TL. BUSINESS_UNIT_NAME contains data?

Ankur Jain--Oracle

Yes it has data . I verified it. Department and job family filters are working but worker category , user person type , gender and all other filters are not . It looks me some security issue.

Regards

Ankur

Sumanth V -Oracle

@Ankur Jain--Oracle - Please check if the user has been assigned the Application Role: HCM Business Unit Data Security. Data Security Assignment for Business Unit Name is based on this role.

Ashish-Oracle

@Ankur Jain--Oracle Yes, it looks like a data security issue. Please ensure, HCM View All Data Security role is assigned to this user.

Refer: Data Roles
https://docs.oracle.com/en/cloud/saas/analytics/24r2/fahia/chapter-subject-areas.html#GUID-C9F7CB8F-7459-4757-A1DC-67F87061E19B

Ankur Jain--Oracle

I have the service administrator role so this should not be the issue.

Sumanth V -Oracle

@Ankur Jain--Oracle - Please check the physical SQL generated and verify if there are references to the 'SEC_SECURE_BY_OBJ_MEMBER_USER' table. This will help determine if data security is still blocking your access.

Ankur Jain--Oracle

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

Sumanth V -Oracle

@Ankur Jain--Oracle - It's designed that way on purpose.

Ankur Jain--Oracle

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