Composite Model and RLS *27

[dfdfdd]

I have a composite model with heriachical RLS applied. The RLS works perfectly fine except when it comes to using data from the direct query table. I have mutliple tables that are all import and 1 single direct query table.

When using data from the direct query model in a table of data, it totals all values instead of just the values specific to the user viewing per the RLS.

For example, the user will be viewing data for their team. Each user within their team shows the correct number of items however the table total shows the total for all values, not just the values relevant to the user viewing. https://www.linkedin.com/events/c-mocomunicarmeconaviancaenbogo7158716458632384513

[lbendlin]

I have a composite model with heriachical RLS applied.

Check your data model connections and makes sure that the arrows point FROM the RLS tables TO the fact tables, NOT the other way round.