How data is stored in Dataset and processed while reporting with RLS:

[SenthilGanesan]

How data is stored in Dataset and processed while reporting with RLS:

e.g. fact has 100 rows, 5 user are there with RLS security to access data.

Table1: FACT 100 rows

TABLE2: Security 5 rows with email tagged

Q: When user1 login RLS applied to show only 10 rows based on the relation with fact table. In this case

1) dataset will have data combined with all combination based on fact and security relations, RLS applied to filter the data

                OR

2) Dataset will join two tables and apply filter on the data in runtime based on user login RLS.

[GilbertQ · Accepted solution]

Hi @SenthilGanesan 

When RLS is applied it first creates a filter and then it queries this data with the filter in place.

In your example this would be number 2