You created a LookML model and a dashboard that displays daily sales metrics for five regional managers. You need to ensure that regional managers can view only the sales metrics for their own region. You want an easy-to-implement solution. What should you do?
A Create a sales_region user attribute, and assign each manager’s region as the value of their user attribute. Add an access_filter Explore filter on the region_name dimension by using the sales_region user attribute. B Create five different Explores with the sql_always_filter Explore filter applied on the region_name dimension. Set each region_name value to the corresponding region for each manager. C Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager. D Create separate Looker instances for each regional manager. Copy the LookML model and dashboard to each instance. Provision viewer access to the corresponding manager. Show Answer Answer Explanation An Explore-level access_filter associates a field with a user attribute and applies a user-specific, non-editable restriction to every SQL query generated from that Explore. Setting each manager’s sales_region attribute to the manager’s region and applying it to the region field enforces regional row-level access while allowing one shared model and dashboard.
Learn more
Community Discussion