Row Level Security for Dataset

my ideas are like below… there will be 4 quicksight reports… feel free to suggest if any better suggestions on this.

1st report will have 4 sheets → Corporate, Community, Caregivers, Residents

                   This report access will be given to only "corporate view users" from RLS

                   Sheet navigations between all above sheets need to be taken care.  It means that if the user on Corporate sheet and looking at the Average response KPI chart with community dimension, clicking on any particular community should navigate him to Community sheet with default filter applied with selected community value.  

                  Like wise, the navigations from Community sheet to Caregiver sheet and from Caregiver sheet to Residents sheet.

                  Also, by clicking on the chart, user should be able to get the raw data shown based on the selected community and measure values

2nd report will be the duplicate of 1st report but with out Corporate sheet.

                 This report access will be given to only "Community view users" from RLS

                 Rest of all the functionality remains the same

3rd report will be the duplicate of 2nd report but with out Community sheet.

                 This report access will be given to only "Caregiver view users" from RLS

                 Rest of all the functionality remains the same

4th report will be the duplicate of 3rd report but with out CommunityCaregiver sheet.

                 This report access will be given to only "Resident view users" from RLS

                 Rest of all the functionality remains the same

if I understand correctly, there are 4 groups of users. Each group have different authority level of data. You have split the dashboard into 4 different sheets with different types of data.
The most powerful user group can see all 4sheets. Other user group can see 1sheet or 2 sheet or 3sheets.
You have created 4 different reports. The first report has all 4 sheets. And the other reports 1-3sheets
So, the question is whether this is the best approach?

Instead of duplicating dashboard, did you considered showing all 4sheets to all user group and use RLS to control the data they can see? that will help to save operation effort.
Another option is, you may create 4 dashboards, each of them has one sheet only. You may add a URL in visual “Text box”, user can click on it and redirect to another dashboard

The benefit is to reduce the number of duplicated dashboard to reduce maintenance effort. Meanwhile trying to maintain the same user experiences

2 Likes