drls
1 Topic
Row level Security on multiple dimension alias table
Hello All, We have a current setup of DW tables one fact which is connected to multiple dimension table, for an example lets take Fact Sales which is connected to multiple Dim Agents tables like Dim-Agent(Who sold the product) , Dim-Agent(who billed the product), Dim-Agent(who serviced the product). which is connected to the fact table different columns like agent_sold, agent_billed, agent_servd. The issue happens when i try to setup row level security for the Agent table, so i tried putting the below code to all the agent table in the row filter under Roles. ='Dim - Agent_sold'[Agent NT Login]=MID(USERNAME(),FIND("\",USERNAME(),1)+1,LEN(USERNAME())-FIND("\",USERNAME(),1)+1) when it is applied to only one table it works fine, but when i started applying to all the agent table it is doing like a inner join and showing the result. Kindly let me know how to handle this situation. Let me know if you need further information ThanksSolved1.6KViews0likes4Comments