Forum Discussion
One Report in Multiple App Workspaces
I need to know the best solution for the following scenario: Say I have two "apps" - one for Sales, one for HR. Sales gets two reports - A and B HR gets one report - A To use report A in an ...
My solution to this issue isn't a pretty one, but at least it works.
Create RLS security for the different departments, so they can use the same reports, yet see different data
Combine the various reports into different dashboards, one dashboard for each individual configuration (HR / Sales)
Then combine all these dashboards, reports en data in one app.
When HR logs in, it will be able to go to report B, but since RLS is setup, they will only see empty pages
Ideally, you want to be able to restrict the ability to see a dashboard within an app based on someones username/group membership, just as you are able to with RLS.