So I have a single table (FactSales) with Sales Value and Profit.
The issue is everyone can see sales for their region
However I want some users to be able to view sales but not profit.
My plan was
- Create a cut down version of FactSales called FactProfit
- Remove the column Profit from FactSales
- Join FactSales to FactProfit
Then the I was hoping I could do like a SQL left join so if there is a value for Profit shpow it. If not zero it.
However in the model it will not let me filter in one direction for a one to one relationship. So when I run a query the security on the profit table means I get no results back from my Sales Table.
Is there a way to deliver Column Level Security In any way \ shape ?