Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
71
Views
9
Comments
S Vamsi
S Vamsi Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

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

  • S Vamsi
    S Vamsi Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner 
    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
    S Vamsi Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner

    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
    mmrsherf Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner

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

  • S Vamsi
    S Vamsi Rank 3 - Community Apprentice


    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]
    [Deleted User] Rank 2 - Community Beginner

    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