- is it detail against everything? Yes - is there any row level security that might force item id into the query? No Please help me out to solve this issue.

And what was the level based dimension / level of granularity that the measure should be reflecting? - from your comment - if I understand you correctly - organization id?? yes, ITEM COST should show data at organization id level of granularity only as report is build on columns from Dim Organization only. ITEM COST…

Thanks Robert Angel for your response. INVENTORY_ITEM_ID is key column for Dim Category Hierarchy and ORGANIZATION_ID is a key column for Dim Organization Hierarchy.ITEM COST is the level based measure which is present in both these hierarchies at its respective granularity level of key column defined in hierarchies.…

I found some information related to this issue in Oracle document. https://docs.oracle.com/cd/E23943_01/bi.1111/e10540/dataaccess.htm#BIEMG299 In this document it is mentioned that "Permissions granted directly to the user take precedence over those granted through application roles." so i have removed explicitly given…

We can see report physical query in the manage session so in the same physical query i should be able to see application role data filters right?Please help me out with this issue.I could not see these application role data filters in physical query is my issue.

Thanks Christian Berg for your reply.How to check whether application role data filters are applied are not ?Where can I see the data filter condition in query? If a user has BI admin role in that case do data filters applied by other application roles are bypassed?