nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Can data filters applied in application roles overwrite the data filters applied at content level of

S Vamsi

I have created a session variable and used this variable as filter condition in content level of logical table BMM level . Create an application role and used another session variable in data filter on the same logical dimension table.For example w_gl_segement_d is the dimension table then content level filter condition is w_gl_segment_d.segment_lov_id in (101525,101526) and filter condition from application role is w_gl_segment_d.segment_lov_id in (101525,0).What will be the final filter condition value which will be applied on w_gl_segment_d.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

No. They get added to the filter of the LTS.

So "Year=2018" in the LTS becomes "Year=2018 and Department=ABC"

S Vamsi

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?

[Deleted User]

S Vamsi wrote:Where can I see the data filter condition in query?

In the query log. Either throught Administration -> Manage Sessions when the user is running it or innthe query.log of the OBIS.

S Vamsi

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.

[Deleted User]

1.) A "report" is a BI Publisher object. An "analysis" is an OBI object. There is a huge difference.

2.) In the query log you can see everything as long as you have at minimum log level 2 active.

mmrsherf

Hello ,

lets assume that when you say "Report" you mean "Analysis" then like what Christian Berg

suggested there you will find the physical query and you should be able to find all the filters applied on your query.

- if you still can't find it then i would double check on

- the data filters

- the application role

- make sure the user you run the analysis by is granted the needed application role.

- make sure you saved and uploaded the rpd after the modifications you have done.

Hope that i helped.

[Deleted User]

...and also that the query doesn't hit the bloody cache!

S Vamsi

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 filter condition from LTS then after i am able to see data filter applied from custom application roles in manage sessions.

Thanks

Vamsi S

[Deleted User]

Ah yes there are seveal snags of course. User-based access never entered into the equation since in th best case the control is managed on application role level and not user-by-user