Forum Discussion

Credo's avatar
Credo
Helper I
7 years ago
Solved

RLS set value - undesired behavior

Hi 

 

I thought I had RLS figured out but I am just puzzled here 

 

I have some sales connected to a Product dimension table with a Category column (A, B, C etc)

 

I have created a role with the only filter being applied to the Category column where [value] = "C"

 

Without the role active, here is what I see on a new report page


 

 

 

 

 

 

also here is a snap of the page level filter for the Categories


 

 

 

 

 

 

 

If I apply the role I see this 

 

 

 

 

 

 

 

 

As you can see the table on the left got filtered correctly and is only showing C, however, the total value on the table as well the visual on the right remains unfiltered. 

 

In addition, the page level filter now only lists C as an available option and it remains unchecked. If I do check it then everything filters correctly. 

 

After some tinkering I discovered that if I manually select each category on the page level filter before applying the role

 

 

 

 

 

 

 

 

 

than when I do apply the role it works as intended

 

 

 

 

 

 

 

 

Can someone explain to me what is going on here? Am I doing something wrong?

 

 

  • I was able to partially resolve the issue by activating "apply security filter in both directions" between a bridge and dim table 

     

    That eliminates the issue for the sample file however it looks like I am out of luck for my work file because I have multiple fact tables connected through multiple bridge tables to a single dim table. I can toggle the security filter checkbox for one of the bridge tables which resolves the issue for that tables and connected data, however, it won't let me toggle security filter for all 4 bridge tables.

     

    Edit:

     

    Alternative workaround - add report level filter for the values that will be filtered by your role.

    Don't check the "select all" box but instead manually tick each box for every value.

11 Replies

    • Credo's avatar
      Credo
      Helper I

      Yes I am running the same version 2.63.3272.40461 64-bit (Октябрь 2018)

       

       

       

      • ssugar's avatar
        ssugar
        Resolver III

        Does the pbix file I linked to in my earlier post work properly for you with RLS?  Is there any difference between your data or your RLS setup and the one I created in the pbix file?