Overwrite RLS

[edubcardoso]

Hey ! 

I am developing a model with RLS but I want some of the visuals to remain unchanged, is this possible ?

For example, I have a company presentation page with the number of customers, number of employees, and other economic indicators, but when I apply RLS, I only get those indicators for each person

How do I get this?

Thanks !!

[Greg_Deckler · Accepted solution]

@edubcardoso So normally I see this implemented with a disconnected aggregation table so that the aggregations are not affected by RLS and can be displayed to everyone. For example, you could create an aggregation table like:

Agg Table = 
  { 
    ( "Customers", COUNTROWS('Customers') ),
    ( "Employees", COUNTROWS('Employees') )
  }

[edubcardoso]

@Greg_Deckler thanks for helping !

With this aggregation table, Can use any measure ? Its just copy the measure and put it in the second argument ?

[amitchandak]

@edubcardoso , You can make those table is not getting filtered using RLS.

Let's say we have Dimension table email and department and that is used in RLS. Then the tables not joining with department will not get filtered