Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Need to understand about the Data filters

Received Response
21
Views
6
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

Hello Team,

I need to understand about the Data Filter how it works in below condition:-

pastedImage_0.png

There is a role created with OBI_Data_Visi_Logistic_role in EM & RDP.

In rpd, when open the property of role I have got the above formula.

I need to understand what is this Limit filter =0 means.

I have seen there is a dimension in rpd with name Logistic claim and in has 2 LTS mentioned in source.

In one LTS the is a column with name Limit filter =0 and in another one its blank.

Please experts guide me how it will work when a user will have the role   OBI_Data_Visi_Logistic_role added to profile.

Kindly let me know if you need some more information.

Thanks for your big help.

Regards,

Abhi

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    typically these are used to apply data / row level security, so your filter is limiting the group in question to be only able to see Global Logistics.Logistics Claim.Limit Filter = 0 in addition (AND Global Logistics....) to any other filters that are applied in the analysis.

    In your case anyone who has the filter applied via the group will not see the rows of data that have a blank limit filter.

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Thanks Robert for your explanation.

    I have one more doubt, if this role has been added via a group to a user and if that user create analysis then will the condition Limit Filter=0 will be added into the physical query in where clause, I tried to find it but I guess no it will not appear correct me if I wrong.

    Regards,

    Abhi

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Yes, you understand me correctly, if any users have this filter associated with them via a group membership then that filter will always be applied to any analysis that that user runs on that subject area.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    And if no one has the filter associated with them via group membership then the filter will do nothing at all.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    If I answered your question can you kindly close it for the benefit of others in the community.

    If you are not sure how then you can use 'Assumed Answered' if you feel you don't want to give points, or mark a reply 'Answered' if you do and want to point others to what you feel answered your question.

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Hi Robert,

    sorry for delay response was pulled into a meeting related to same issue.

    I will start a new thread as I am facing a new problem related to same issue.

    However, thank you for quick suggestion in right direction.

    Thanks & Regards,

    Abhi