Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unable configure RLS properly with two fact tables

 

We have two fact tables mapped with date and created summerize tables for each attribute as dim table(account name,employeeid,country) inorder to use in the slicers, we have one more dimension table Account manager for RLS,

when RLS table mapped with Table A, table A related report is working and table B report is also working, but when we choose vol or Invol in the slicer then visuals are breaking ,,,,,

simillarly if we map RLS table with Table B , Table B report is working slicer choose also working but Table A report is not working..

 

Please any one can help with scenario how can get the solution..

General Comment

2 Replies

  • CoreyP's avatar
    CoreyP
    Solution Sage
    2 years ago

    I'm not totally clear. So you have an RLS table, which is a table of employees? And this table relates to your fact table on... a category? or each row of your fact has an e-mail associated? It almost sounds like you need to change your relationship to bi-directional.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    we have emailid each row in fact table(Table A) and we tried with bi directional,

    Then Table A report is filtering based on RLS role, Table B data report is not filtering when we select vol/Invol in slicer